Database Normalization
Problem
Every order stores:
CustomerName
CustomerAddress
CustomerEmail
Alice places 1,000 orders.
Her address now exists in 1,000 places.
Updating it consistently becomes difficult.
Solution — Normalization
Separate related facts.
Customer ↑ Order → CustomerId
Core idea: normalization reduces unnecessary duplication and update inconsistencies in relational data.