A table design is in second normal form (2NF) if it is in 1NF and if all fields that are not part of the primary key are functionally independent on part of the primary key.

Name: A table design is in second normal form (2NF) if it is in 1NF and if all fields that are not part of the primary key are functionally independent on part of the primary key.
Brand: Quizplus
Rating: 4.8 (35 reviews)

Question

Quizplus · Accepted Answer

A table is in 2NF if it is in 1NF and all non-key attributes are fully functionally dependent on the entire primary key, not just part of it.

A Table Design Is in Second Normal Form (2NF) If