Normalization Through 3NF
First, second, and third normal form with the anomalies they remove.
Why Interviewers Ask About Normalization
Normalization is a database modeling fundamental, and interviewers use it to test whether you understand data integrity at the design level. The question often sounds like: "What is normalization and why does it matter?"
Normalization is the process of organizing columns and tables to reduce redundancy and prevent update, insert, and delete anomalies. Each normal form (1NF, 2NF, 3NF) adds a stricter rule.
A strong answer names the anomalies normalization removes, not just the textbook definitions.
The Three Anomalies
Before the normal forms, learn the problems they solve. A poorly designed table that stores everything in one place suffers three anomalies:
- Update anomaly: the same fact is stored in many rows, so a change must touch all of them or data goes inconsistent.
- Insert anomaly: you cannot add a fact without also supplying unrelated data (e.g. cannot add a product without an order).
- Delete anomaly: deleting one row accidentally erases another independent fact.
If you can spot these in a sample table, you can justify every normalization step.