Normalization
Organizing database tables to reduce redundancy by splitting data into related tables connected by foreign keys. Follows normal forms (1NF, 2NF, 3NF).
What is Normalization?
Organizing database tables to reduce redundancy by splitting data into related tables connected by foreign keys. Follows normal forms (1NF, 2NF, 3NF).
Normalization is a foundational concept that sits in the Database Fundamentals area of system design. Engineers reach for it whenever they need to reason about real-world trade-offs in that space — not just for textbook correctness, but because real production systems at companies like Netflix, Amazon, and Google make these decisions every day.
If you want to go deeper than this definition — with diagrams, code, and a quiz to lock it in — work through the "Normalization" lesson linked below. It walks through the why, the mechanism, the trade-offs, and how the giants actually use it in production.
Learn Normalization in depth
Full interactive lesson with diagrams, code examples, real-world references, and a quiz.
Open the Normalization lessonRelated lessons
Lessons that touch on Normalization as part of a larger topic.
Database Normalization
1NF through 3NF, eliminating redundancy, update anomalies, and data corruption the structured way
foundation · database fundamentals
Vertical Partitioning
Splitting a wide table by columns, keeping hot data tight and cold data out of the way
foundation · database fundamentals
Data Transformation
Convert data from one format, structure, or representation to another, the glue between incompatible systems
intermediate · data governance compliance
Database Denormalization
Intentionally adding redundancy for read performance, when breaking the rules is the right call
foundation · database fundamentals
Database Triggers
Automatic reactions to data changes, audit logs, denormalization sync, and the hidden complexity they bring
foundation · database fundamentals
See also
Related glossary terms you might want to look up next.
Denormalization
Intentionally adding redundant data to database tables to speed up read queries by avoiding expensive joins. Trades storage and write complexity for read performance.
SQL
Structured Query Language for managing relational databases. Tables, rows, columns, and powerful joins to query related data.
Foreign Key
A column in one table that references the primary key of another table, enforcing referential integrity between related tables.