alleryStart learning →Role names in an ER diagram are essential for
Aany relationship of degree higher than 2
Brecursive relationships, where the same entity is on both sides
Cevery weak entity that depends on a strong owner
Drelationships between entities in different databases
Answer & Solution
Correct answer: B. recursive relationships, where the same entity is on both sides
On a recursive relationship like prereqOf(Course, Course), you must label which Course end is which (the pre-requisite vs the dependent).
**NPTEL:** 'Role Names: essential in case of recursive relationships.
Can be optionally specified in non-recursive cases.' Higher-degree relationships don't strictly require role names.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.