Database Design, 3NF, Removing Transitive Dependencies

3NF, Removing Transitive Dependencies

A table is in the third normal form if it meets the following criteria:

1. It shoould be in 2NF.
2. It should not have any transitive dependencies. 

• a transitive dependency describes a situation in which changing a non-key column in a table affects another non-key column in that table . For example in the table below, if we decided to change either FirstName or LastName then we would have to also change the data in the Initials column.

In the above table the Initials column has a transitive functional dependency. therefore it is removed and inserted into a new table in order to achieve 3NF.

our tables are now in the third normal form.