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

This question was posed to me in an internship interview.

Query is from Multivalued Dependencies in division Normalization of Database Management

Answer 1

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

For 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.