Question

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

(a) A many-to-many relationship set

(b) A multivalued attribute of an entity set

(c) A one-to-many relationship set

(d) All of the mentioned

The question was asked in an international level competition.

Origin of the question is Database Design Process in section Normalization of Database Management

Answer 1

Correct option is (b) A multivalued attribute of an entity set

For explanation: If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from this source.