A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.

Question

Quizplus · Accepted Answer

This statement is true. 3NF builds on the rules of 2NF and requires that all non-key attributes are dependent only on the primary key, or on another non-key attribute. If a non-key attribute is determined by another non-key attribute, then it violates the rules of 3NF.

A Relation Is in 3NF If and Only If It