GATE 2024 CS (CS2) – Question 20
Databases · ER-Model and Database Architecture · 1 mark · Multiple choice
In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?
- The weak entity set MUST have total participation in the identifying relationship
- The owner entity set MUST have total participation in the identifying relationship
- Both weak and owner entity sets MUST have total participation in the identifying relationship
- Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship
Practise this question in The GATE Grind →
Show answer and explanation
Correct answer: (A) The weak entity set MUST have total participation in the identifying relationship
Explanation
A weak entity cannot exist without its owner, so it must totally participate in the identifying relationship. The owner need not participate totally.
More ER-Model and Database Architecture questions
- GATE 2020 CS Q24 – Which one of the following is used to represent the supporting many-one relationships of a…
- GATE 2018 CS Q21 – In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity…
- GATE 2015 CS (CS1) Q48 – Consider an Entity-Relationship (ER) model in which entity sets E 1 and E 2 are connected…
- GATE 2017 CS (CS2) Q27 – Entity types A and B are connected by relationship R with no attributes. When can the…
- GATE 2012 CS Q24 – For basic ER and relational models, which is incorrect?
- GATE 2021 CS (CS2) Q16 – S1: A relation schema can have at most one foreign key. S2: A foreign key in schema R…
All ER-Model and Database Architecture questions →