Normalization Journey 1NF to 3NF¶
Run the Normalization MicroSim Fullscreen
About This MicroSim¶
A four-step walk-through of normalization. Start with a denormalized Order Report. Step into 1NF (split multivalued column into OrderLine), then 2NF (extract Product), then 3NF (extract Salesperson). At each step you see the violated rule, the update anomaly it creates, and the structural fix.
Click Show Update Anomaly Cost to see how many rows must change for a simple rename in the violating schema vs the normalized schema.
Lesson Plan¶
Learning Objectives¶
By the end of this activity, students will be able to:
- Identify 1NF, 2NF, and 3NF violations in a given table
- Propose the structural fix for each violation
- Quantify the update-anomaly cost of leaving a violation in place