Database Normalization Concepts

Q: Explain database normalization. A: Normalization is the process of organizing relational schema to reduce data redundancy and avoid update/insert/delete anomalies, done through a series of normal forms: 1NF (atomic column values, no repeating groups), 2NF (1NF + every non-key column fully depends on the whole primary key, eliminating partial dependency for composite keys), and 3NF (2NF + no transitive dependencies, i.e., non-key columns depend only on the key, not on other non-key columns). Higher forms (BCNF, 4NF) handle more subtle anomalies. In practice, systems often deliberately denormalize (duplicate data) to optimize read-heavy paths at the cost of redundancy and more complex writes, a common trade-off discussed alongside normalization theory.