When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:
A) second normal form.
B) third normal form.
C) fourth normal form.
D) fifth normal form.
E) a relational form.

Question

Quizplus · Accepted Answer

If each nonprimary key attribute is identified by the whole key, then the relation is in second normal form. This means that each nonprimary key attribute is dependent only on the entire primary key and not on a subset of it. It eliminates the possibility of partial dependencies within the relation.

When Each Nonprimary Key Attribute Is Identified by the Whole