Question

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship 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 my homework.

This is a very interesting question from Database Design Process topic in chapter Normalization of Database Management

Answer 1

Correct option is (a) A many-to-many relationship set

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