What is a Data Anomaly?

A data anomaly is a fault in the database. It occurs when there's a deviation from the normal pattern of the database due to a glitch or error. In most cases, normalization helps correct anomalies. But it's common for several to slip through the cracks.