Normalization vs Denormalization
Normalization vs Denormalization
MediumDatabases0% accepted
An e-commerce schema duplicates customer address in every order row. Explain normalization (1NF→3NF) and when denormalization is actually the right choice. Cover: what each normal form removes, the update-anomaly problem with duplication, and why read-heavy analytics systems often denormalize on purpose.
Approach
Normalization removes redundancy (3NF: no transitive dependencies) to prevent update anomalies. Denormalization re-introduces redundancy to avoid joins on read-heavy paths — a deliberate read-vs-write trade-off.
More Databases problems
Browse all coding problems →Scenarios & Expected Answers
No example scenarios for this problem.
Sign in to continue
Create a free account to view answers and mark progress.
- Free forever — no credit card
- Theory Q&A with detailed answers
- Points, streaks & leaderboards