Learn how to normalize your relational tables.
- 1st Normal Form and Atomic Values
- 2nd Normal Form (2NF) and Partial Dependence
- 3rd Normal Form (3NF) and Transitive Dependence
- 4th Normal Form (4NF) and Multi-Valued Facts
The first half of the video discusses the normal forms with smaller examples. The second half of the video goes into a little more complex example.
Video: Database Normalization Tutorial
1NF, 2NF, 3NF, 4NF
The following Microsoft Excel file is used throughout the training to demonstrate the normal forms:
See the original Normalization in SQL. 1NF, 2NF, 3NF, and 4NF video.