Find Facts Stored More Than Once

An update anomaly occurs when the same fact is stored in several rows and only some copies change. A wide order table repeats customer and product facts for every line item. Normalization separates facts by what determines them, reducing the places that one change must reach.