Home › GATE CSE › computerscience › Database Management Systems › Age is best modelled as which kind of attribute?
Age is best modelled as which kind of attribute?
Aderived from DateOfBirth and today's date
Bcomposite of year and month components
Cmulti-valued, one entry per birthday
Dsimple single-valued, stored on every form
Answer & Solution
Correct answer: A. derived from DateOfBirth and today's date
Age changes every year while DateOfBirth is stable. Storing Age directly means it goes stale. NPTEL's example uses exactly this: Age depends on DateOfBirth, so it is a derived attribute, computed when needed rather than stored.
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