What are insertion, update, and deletion anomalies?

An insertion anomaly occurs when one fact cannot be stored without supplying unrelated data. An update anomaly occurs when the same fact is duplicated in several rows and must be changed everywhere. A deletion anomaly occurs when deleting one record unintentionally removes another independent fact.

Normalization reduces these anomalies by separating facts into appropriately related tables.