Converting a table into the second normal form applies to a table that has a composite key.

Question

Quizplus · Accepted Answer

The second normal form (2NF) applies to tables that have a composite key, which means the table has more than one column that serves as the primary key. The 2NF requires all non-key attributes to be functionally dependent on the entire composite key, not just on part of it. If a table does not have a composite key, then it cannot be put into 2NF.

Converting a Table into the Second Normal Form Applies to a Table