Start learning →

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.
Practise this question with Quill — GATE CSE →

Keep practising Database Management Systems

Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.

Start a Database Management Systems lesson →
Related questions