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. 7. 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. Both a and b
Answer:A
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. 7. 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. Both a and b
Explanation: If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from this source. 8. In which of the following , a separate schema is created consisting of that attribute and the primary key of the entity set.