In which of the following, a separate schema is created consisting of that…
2023
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.
None of the mentioned
Attempted by 935 students.
Show answer & explanation
Correct answer: B
Answer: B
Explanation: When an entity has a multivalued attribute, a separate schema is created to store the attribute values. This schema includes the primary key of the entity and the attribute itself. This ensures that each value of the multivalued attribute is stored separately, maintaining data integrity.