A relation is in third normal form (3NF)if and only if it is in 2NF and ________.
A)all non-key attributes are determined by the entire primary key
B)there are no non-key attributes determined by another non-key attribute
C)every attribute is a candidate key
D)every candidate key is a determinant
E)every determinant is a candidate key

Question

Quizplus · Accepted Answer

In 3NF, there should be no non-key attributes determined by another non-key attribute. This ensures that there are no transitive dependencies and the relation is fully normalized. 2NF ensures that there are no partial dependencies, but it does not guarantee the absence of transitive dependencies. Therefore, the correct answer is B.

A Relation Is in Third Normal Form (3NF)if and Only