beginnerDatabase Design — Normalization, Denormalization & Multi-Tenant

What are the first three normal forms and why do they matter?

1NF: Every column holds atomic (indivisible) values. No arrays, no comma-separated lists. Each row is unique. Example violation: storing 'Engineering, Marketing' in a single column. 2NF: 1NF + no partial dependencies. Every non-key column must depend on the ENTIRE primary key (relevant when PK is composite). Example violation: storing product_name in order_items when PK is (order_id, product_id) —

Ready to master this question?

Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.

Next Step

Continue to What is the difference between the three multi-tenant database patterns? →← Back to all SQL questions