Relational Database Normalization Tool
Design, normalize, and visualize database schemas from 1NF to 3NF.
Click attributes below to toggle them as part of the Primary Key.
E.g., "ZipCode determines City".
→
Normalization Breakdown
1NF (First Normal Form)
The Universal Relation
2NF (Second Normal Form)
Removes Partial Dependencies
3NF (Third Normal Form)
Removes Transitive Dependencies
Entity Relationship Diagram (3NF)
Normalization Guide
1. First Normal Form (1NF)
Ensure atomicity. A table is in 1NF if every cell contains a single value and there are no repeating groups.
2. Second Normal Form (2NF)
Must be in 1NF. Remove Partial Dependencies. This occurs when a non-key attribute depends on only part of a composite Primary Key.
If PK is (A, B) and A → C, then C is partially dependent. Move A and C to a new table.
3. Third Normal Form (3NF)
Must be in 2NF. Remove Transitive Dependencies. This occurs when a non-key attribute depends on another non-key attribute.
If A → B and B → C (where A is PK), then C is transitively dependent on A via B. Move B and C to a new table.
Notice
Message