Skip to interview prep
Apexed

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.

What is normalization, and when would you denormalize — Software engineering interview question — Apexed