A relation is in second normal form (2NF) if it is in first normal form (1NF) and:
A) if the only determinants it contains are candidate keys.
B) no non-key attribute is dependent on only a portion of the primary key.
C) it does not contain any repeating groups.
D) computed fields are eliminated.

Question

Quizplus · Accepted Answer

A relation is in 2NF if it is in 1NF and every non-prime attribute is fully functionally dependent on the primary key, meaning no non-key attribute is dependent on only a portion of the primary key.

A Relation Is in Second Normal Form (2NF) If It