A table is in second normal form when it is in first normal form and _____.
A)each nonkey column is dependent on the entire primary key field
B)it contains candidate keys
C)it allows no data modification anomalies
D)it contains at least one foreign key field

Question

Quizplus · Accepted Answer

A table is in second normal form (2NF) when it is already in first normal form (1NF) and every non-prime attribute is fully functionally dependent on the primary key. This means each nonkey column must depend on the entire primary key, not just part of it, if the primary key is composite.

A Table Is in Second Normal Form When It Is