A table is in 2NF if it fulfills these two conditions: it is in 1NF,and it has ____ dependencies.
A)no partial
B)no total
C)all partial
D)all total

Question

Quizplus · Accepted Answer

2NF requires that a table be in 1NF and contain no partial dependencies. Partial dependencies occur when a non-key attribute is functionally dependent on only a portion of the primary key. Therefore, option A, which states that there should be no partial dependencies, is the correct answer.

A Table Is in 2NF If It Fulfills These Two