Structuring tables to avoid redundant, inconsistent data — and knowing when to deliberately break the rules for performance.
Q1.What problem does normalization primarily solve?
Q2.What does Third Normal Form (3NF) additionally require beyond 2NF?
Q3.What is a primary reason to deliberately denormalize a schema?
Q4.What is a foreign key constraint primarily used for?