Database Normalization Examples -
Assume a video library maintains a database of movies rented out. Without any normalization, all information is stored in one table as shown below
1NF (First Normal Form) Example
2NF (Second Normal Form)
It is clear that we can't move forward to make our simple database in 2nd Normalization form unless we partition the table above
Table 1
Table 2
3NF (Third Normal Form)
To move our 2NF table into 3NF, we again need to again divide our table.
Table 1
Table 2
Table 3
We have again divided our tables and created a new table which stores Salutations.
There are no transitive functional dependencies, and hence our table is in 3NF
In Table 3 Salutation ID is primary key, and in Table 1 Salutation ID is foreign to primary key in Table 3
