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

Question

Quizplus · Accepted Answer

A relation is in Second Normal Form (2NF) if it is in First Normal Form (1NF) and every non-primary key attribute is fully functionally dependent on the primary key. This means that there should be no partial dependency of any column on the primary key.

A Relation Is in ________ If Every Non-Primary Key Attribute