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.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.