Normalization vs denormalization — what’s the trade-off?

Answer

Normalization reduces redundancy and update anomalies by splitting data into related tables. Denormalization duplicates some data to speed up reads and reduce joins, at the cost of harder writes and consistency management.