Home › GATE CSE › computerscience › Database Management Systems › A student's set of email addresses is best model…
A student's set of email addresses is best modelled as
Aa derived attribute based on the roll number
Ba multi-valued attribute (one student, many emails)
Ca composite attribute with username and domain parts
Da separate entity called EmailAddress
Answer & Solution
Correct answer: B. a multi-valued attribute (one student, many emails)
A student commonly has more than one email (personal, institute, work). That is the textbook case for a multi-valued attribute. NPTEL lists it: 'EmailAddress attribute for student' is given as a multi-valued example. Composite would mean splitting one address into parts; derived would mean computing it.
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