contestada

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.

Respuesta :

Answer:

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

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.