1. What is normalization and why does it require SQL joins?
- Normalization encrypts tables on disk.
- Normalization splits data into separate logical tables to eliminate duplication, requiring Joins to reconstruct relations.
- Normalization merges all data into one single table.
- Normalization restricts table rows.
Hint: Normalization keeps data organized and non-redundant (e.g. storing address separately from customer profiles), requiring JOIN operations to stitch them back together.