The Relational Model and Normalization - Technical MCQs

Q1:

One solution to the multivalued dependency constraint problem is to:

A split the relation into two relations, each with a single theme.

B change the theme.

C create a new theme.

D add a composite key.

ANS:A - split the relation into two relations, each with a single theme.

Split because its full constraint avoids anomalies.