GATE CSE 2020 Q24: ER notation for the identifying relationship of a weak entity
- Databases
- 1 mark
- MCQ
- −1/3 if wrong
Question
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
Try it: multiple choice: exactly one correct option
Wrong answer costs 1/3 mark in GATE.
Show answer and explanation
Answer: A (official GATE 2020 final answer key)
Concept used: ER notation: relationships are diamonds, entity sets rectangles, attributes ovals; double borders mark weak or identifying constructs.
First step: A supporting (identifying) relationship is a relationship, so its shape is a diamond.
Full step-by-step solution
Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.
Share this question
Source: official GATE 2020 CS question paper and final answer key, organised by IIT Delhi. Question paper · Answer key
More Databases PYQs
- 2026 Session 1 · Q30Which functional dependency inferences always hold
- 2026 Session 1 · Q31Dependency-preserving decompositions for 1NF, 2NF, 3NF, BCNF
- 2026 Session 1 · Q43Relational algebra equivalent of a tuple calculus join query
- 2026 Session 1 · Q65Number of superkeys with candidate keys {A,B} and {A,C}
- 2026 Session 2 · Q15Match DBMS schema levels with what they describe
- 2026 Session 2 · Q20When two transactions do not conflict on a data item