In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2024 Set 2 · Q20
Time
Select one answerSingle correct
Solution
Official answer: A) The weak entity set MUST have total participation in the identifying relationship
ER ModelIn an Entity-Relationship (ER) model:
A weak entity set is an entity set that does not possess sufficient attributes to form a primary key on its own. It relies on an identifying (owner) entity set for identification.
Each weak entity must be associated with an owner entity to be uniquely identified. Consequently, the weak entity set MUST have total participation (existence dependency) in the identifying relationship set.
The owner entity set, however, can contain entities that do not associate with any weak entity, meaning its participation in the identifying relationship is typically partial.
Hence, statement (A) is TRUE.
Try the question first, then check your work.
Examiner trap
Consider whether a weak entity instance can exist in the database without being associated with an owner entity.
This ER Model previous year question is Q20 of the GATE CSE 2024 Set 2 paper. Find more GATE CSE PYQs on ER Model in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related ER Model PYQs now with no account.
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
ER Model has 8 GATE CSE PYQs across 8 papers from 2012 to 2026. 7 of them are 1-mark MCQs like this one, and it is the only one in GATE CSE 2024 Set 2.
How GATE tests ER ModelIndependent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.