A relation is in second normal form (2NF)if and only if it is in 1NF 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

A relation is in 2NF if it is in 1NF and all non-key attributes are fully functionally dependent on the entire primary key, meaning no partial dependency on a subset of the primary key.

A Relation Is in Second Normal Form (2NF)if and Only