In which of the following, a separate schema is created consisting of that…
2024
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
Attempted by 504 students.
Show answer & explanation
Correct answer: B
Answer: b
Explanation: A multivalued attribute of an entity set cannot be stored directly in the entity table. Instead, a separate schema is created that includes the attribute and the primary key of the entity set. This is the standard approach to handle multivalued attributes in database design.