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.
Answer: Option A
This Question Belongs to Database >> The Relational Model And Normalization
Related Questions on The Relational Model and Normalization
A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.
A. normal forms.
B. referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.
Join The Discussion