Home › GATE CSE › computerscience › Database Management Systems › A student's grade earned in a particular course …
A student's grade earned in a particular course is best modelled as
Aan attribute of the enrolls relationship between Student and Course
Ban attribute of the Student entity, since the student earned it
Can attribute of the Course entity, since the course assigned it
Da separate weak entity with grade as the only attribute
Answer & Solution
Correct answer: A. an attribute of the enrolls relationship between Student and Course
Grade is meaningful only as 'this student in that course'. Storing it on Student is wrong (one student has many grades, one per course). Storing it on Course is wrong (the course has one grade per student, not one overall). It belongs to the enrolls relationship.
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