Q14: What is database normalization, and when might denormalization help?
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.