A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.

Question

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.​

Quizplus · Accepted Answer

A table is in 3NF if it is in 2NF and every non-key field is not only functionally dependent on the primary key but also every non-key field is non-transitively dependent on the primary key, meaning there are no transitive functional dependencies.

A Relational Database Table Is in Third Normal Form (3NF)if