When is a 1NF table automatically a 2NF table?
A) when two or more columns make up the primary key
B) when there are no interrelation constraints
C) when there are only nonkey columns
D) when the primary key contains only a single column

Question

Quizplus · Accepted Answer

When the primary key contains only a single column, there can be no partial dependencies and therefore no need for further normalization into 2NF. If there are multiple columns in the primary key, then there may be dependencies between non-key columns, which would require further normalization.

When Is a 1NF Table Automatically a 2NF Table