If a table is in 1NF and only has one field in the primary key,it automatically is in 2NF.

Question

Quizplus · Accepted Answer

If a table is in 1NF and has a single field in the primary key, it automatically satisfies the requirements for 2NF. This is because 2NF requires that a table be in 1NF and that all non-key attributes are dependent on the entire primary key, not just a portion of it. If the primary key consists of only one field, then all non-key attributes must be dependent on that field, and the table will therefore be in 2NF.

If a Table Is in 1NF and Only Has One