Question

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

(a) A many-to-many relationship set

(b) A multivalued attribute of an entity set

(c) A one-to-many relationship set

(d) Both A many-to-many relationship set and A multivalued attribute of an entity set

I have been asked this question in quiz.

I need to ask this question from Database Design Process topic in section Normalization of Database Management

Answer 1

The correct choice is (d) Both A many-to-many relationship set and A multivalued attribute of an entity set

Explanation: For a many-to-many relationship set each related entity set has its own schema and there is an additional schema for the relationship set. For a multivalued attribute, a separate schema is created consisting of that attribute and the primary key of the entity set.