Second normal form can be defined as a table that is in first normal form but that contains no ____.
A) partial dependencies
B) alternate keys
C) nonkey columns
D) interrelation constraints

Question

Quizplus · Accepted Answer

Second normal form ensures that every non-key column is fully dependent on the primary key, not on just part of it. This eliminates partial dependencies, where a non-key column depends on only a portion of the primary key. Alternate keys and interrelation constraints do not affect normalization to second normal form.

Second Normal Form Can Be Defined as a Table That