Question

Tables in second normal form (2NF):

(a) Eliminate all hidden dependencies

(b) Eliminate the possibility of a insertion anomalies

(c) Have a composite key

(d) Have all non key fields depend on the whole primary key

The question was asked in an online quiz.

My question comes from Normal Forms in chapter Normalization of Database Management

Answer 1

Correct option is (a) Eliminate all hidden dependencies

For explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.