TSV
Database Normalization Forms - TSV
Database normalization forms are a set of progressive rules defined in relational database design to eliminate data redundancy and maintain data integrity. They exist from First Normal Form (1NF) to Fifth Normal Form (5NF), each addressing specific data dependency issues. Generally, applying up to Third Normal Form (3NF) ensures practically sufficient data quality. Normalization prevents inconsistencies during updates and improves database maintainability and efficiency.
database
normalization
relational database
data design
SQL
code slug name description keyRule level
1NF first-normal-form First Normal Form A state where each cell in a table contains only a single value, eliminating repeating groups. Store only single values (atomic values) and eliminate repeating groups 1
2NF second-normal-form Second Normal Form A state that satisfies 1NF and eliminates partial functional dependencies on the primary key. Non-key attributes must be fully dependent on the entire primary key 2
3NF third-normal-form Third Normal Form A state that satisfies 2NF and eliminates transitive functional dependencies. No dependencies exist between non-key attributes 3
BCNF boyce-codd-normal-form Boyce-Codd Normal Form A state with stricter conditions than 3NF where all determinants are candidate keys. All determinants must be candidate keys 4
4NF fourth-normal-form Fourth Normal Form A state that satisfies BCNF and eliminates multi-valued dependencies. Eliminate multi-valued dependencies by splitting independent multi-valued attributes into separate tables 5
5NF fifth-normal-form Fifth Normal Form A state that satisfies 4NF and eliminates join dependencies. Eliminate join dependencies by decomposing into semantically independent tables 6