Home › GATE CSE › computerscience › Database Management Systems › If every department in a university MUST have a …
If every department in a university MUST have a head professor, this constraint on Department's side of the (Department, headed_by, Professor) relationship is
Amany-to-many cardinality
Ba partial participation constraint
Ctotal participation of Department in headed_by
Da recursive relationship from Department to itself
Answer & Solution
Correct answer: C. total participation of Department in headed_by
'Every X must participate' is total participation. It is NOT a cardinality statement (cardinality asks how many on the other side per entity, not whether every entity participates). Partial would say only some departments have heads. Recursive would mean Department relates to Department, not Professor.
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