A table is in a third normal form when the following conditions are met − It is in second normal form. All nonprimary fields are dependent on the primary key. The dependency of these non-primary fields is between the data. For example, in the following table the street name, city and the state are unbreakably bound to their zip code.

Below is a 3NF example in SQL database: 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

Example of Third Normal Form (3NF) employee_roles Table employees Table jobs Table states Table Now our database is in 3NF.