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

Question

Quizplus · Accepted Answer

A relation is in the second normal form if all non-primary key attributes are fully functionally dependent on the entire primary key, which means they are identified by the whole key.

When Each Nonprimary Key Attribute Is Identified by the Whole