Home › GATE CSE › computerscience › Database Management Systems › Role names in an ER diagram are essential for
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.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment