Practice mode DBMS and SQL

In an ER model, Employee has an attribute age that is calculated from the stored attribute date_of_birth. What kind of attribute is age?

Correct answer C. Derived attribute

Explanation

A derived attribute has a value that can be computed from other attributes, so it is usually not stored; age is derived from date_of_birth and today's date. A composite attribute is made of sub-parts, such as name split into first and last name. A multivalued attribute holds several values for one entity. Storing age would make it go out of date every year.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.