Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2020 · Q14
MCQ1 markEasy
Time
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
Select one answerSingle correct
Pick an option to check
Solution
Step-by-step verified solution
Official answer: A) Diamonds with double/bold border
ER ModelIn standard Entity-Relationship (ER) modeling:
An identifying relationship (the supporting many-to-one relationship that connects a weak entity set to its identifying/owner entity set) is represented by a diamond with a double/bold border (identifying relationship set).
A weak entity set is represented by a rectangle with a double/bold border.
Multivalued attributes are represented by ovals with a double/bold border.
Primary key attributes of strong entity sets are underlined ovals, while discriminator (partial key) attributes of weak entity sets are dashed-underlined ovals.
Therefore, option A is the correct answer.
Try the question first, then check your work.
Examiner trap
The misconception this question tests
Recall the ER diagram notation for an identifying relationship set connecting a weak entity set to its strong entity set.
This ER Model previous year question is Q14 of the GATE CSE 2020 paper. Find more GATE CSE PYQs on ER Model in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Where do you stand for GATE?
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.
One GATE CSE PYQ every morning
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
ER Model in GATE CSE
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 2020.
How GATE tests ER ModelMore from GATE CSE 2020
- Q16What is the worst case time complexity of inserting n elements into an empty linked list, if the linked list needs to be maintained in sorted order?MCQ1 markEasy
- Q12Consider the following statements about process state transitions for a system using preemptive scheduling. I. A running process can move to ready state. II. A…MCQ1 markEasy
- Q17Let R be the set of all binary relations on the set {1,2,3}. Suppose a relation is chosen from R at random. The probability that the chosen relation is reflexi…NAT1 markEasy
- Q11Consider allocation of memory to a new process. Assume that none of the existing holes in the memory will exactly fit the process’s memory requirement. Hence,…MCQ1 markMedium
Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.