25. What is normalization, and when would you denormalize?
MediumDatabases
Technical
Show model answer
Normalization splits data into tables so each fact is stored once, removing update anomalies (first, second and third normal forms are the usual targets).
Denormalize when read performance matters more than write simplicity, for example storing a precomputed count or copying fields into a reporting table, and accept the cost of keeping copies in sync.