Home › GATE CSE › computerscience › Database Management Systems › Students enrolling in courses is typically model…
Students enrolling in courses is typically modelled with which cardinality ratio?
A1:1, one student to one course
B1:N, one student to many courses
CN:1, many students to one course
DM:N, many students enrol in many courses
Answer & Solution
Correct answer: D. M:N, many students enrol in many courses
Each student takes many courses in a semester, and each course has many students enrolled. That is M:N. 1:1 would mean each student takes only one course AND each course has one student; 1:N or N:1 would only constrain one side. Real enrollment is two-sided many-to-many.
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