Q14: What is database normalization, and when might denormalization help?

Difficulty:MediumTopic:Data Modeling

Normalization reduces duplication and update anomalies by separating related entities into well-defined tables. Denormalization duplicates or precomputes data to make common reads faster or simpler, such as storing a product name in an order snapshot. Denormalization increases write complexity and the chance of inconsistent copies. Use it intentionally, define the source of truth, and provide a repair or rebuild path.

Key Takeaways
  • Normalize for integrity; denormalize for measured access-pattern benefits.
  • Duplicated data needs an ownership and reconciliation strategy.