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

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 primary key, meaning they are determined by the entire primary key and not just a part of it.

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