Update and Deletion Anomalies
When a fact is stored in many rows, partial updates create contradictions and deleting a row can erase a fact kept nowhere else. Normalization prevents both.
-
-
Denormalization
Denormalization copies facts into more places so reads get simpler or faster. The price: every copy must be kept consistent by something other than the schema.