Question

A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key.

A) 1NF
B) 2NF
C) 3NF
D) 4NF

Answer 1

A relation is in second normal form (2NF) when every non-primary key attribute depends on the entire primary key, not just part of it.

Step-by-step explanation:

A relation is in second normal form (2NF) if every non-primary key attribute is functionally dependent on the whole primary key. In other words, for a relation to achieve 2NF status in database normalization, there should be no partial dependency of any non-primary key attribute on a part of a composite primary key. In a composite key scenario, each non-primary key attribute must depend on all parts of the composite key.