Tag third normal form in dbms

A relation is in 3NF(What is the 3NF example) or the third normal form if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key. By the transitive functional dependency, we mean…