The Relational Model and Normalization

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.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.