What is normalization in databases?
Why Interviewers Ask This
This is a classic screening question for Database Design / Normalization roles. Hiring managers ask it early in interviews to gauge your baseline understanding and determine if you can communicate technical concepts clearly.
Answer
Normalization is the process of organizing a relational database to reduce data redundancy and improve data integrity by dividing large tables into smaller, related tables. It follows a set of rules called normal forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF), each building on the previous. Benefits: eliminates data anomalies (update, insert, delete anomalies), reduces storage, and makes relationships explicit. The tradeoff: more JOINs are required to reconstruct data, which can impact read performance — this is why denormalization is sometimes applied strategically in high-read applications.
Pro Tip
This topic has Database Design / Normalization-specific nuances that differ from general programming. Highlighting those nuances in your answer shows expertise rather than generic knowledge.