Question

Tables in second normal form (2NF) ______ . Select the correct answer to fill in the gap.

a.Have a composite key.
b.Have all non-key fields depend on the whole primary key.
c.Have all non-key fields depend on part of the primary key.
d.Have no dependencies between non-key fields and the primary key.

Answer 1

Tables in second normal form (2NF) have all non-key fields depend on part of the primary key. Letter C

Step-by-step explanation:

Because 2nd Normal Form (2NF), in a table if attribute B is functionally dependent on A, but is not functionally dependent on a proper subset of A, then B is considered fully functional dependent on A. For this reason, all non -key attribrutes cannot depend on a subset of the primary key.