Tech_Interview_Prep

Schema Design & Normalization

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?