# Update Anomaly

*noun*

say it: **“up-DAYT uh-NOM-uh-lee”** **/ʌpˈdeɪt əˈnɒməli/**

A problem in a poor table design where changing one fact means changing many rows, and missing one leaves the data inconsistent.

## What is **Update Anomaly** in a relational database?

**Update Anomaly** — A design problem where repeated copies of one fact can become inconsistent during an update.

## In a sentence

- “Storing the customer's phone on every order caused an **update anomaly** when it changed.”

Level: Journeyman · [More Database terms at this level](https://www.ask-codey.com/glossary?category=database&level=3)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/update-anomaly
