Stored and Derived Attributes

For Complete YouTube Video: Click Here

In this class, we will understand Stored and Derived Attributes.

Table of Contents

For example, consider employee entity type with the attributes name, date of birth, and age, as shown below.

The attribute values stored in the database are stored attributes.

In the above example, the stored attributes are name and date of birth.

The attribute values derived from the stored attributes are derived attributes.

In the above example, age cannot be a stored attribute.

The value of age has to be updated every year.

So, we can derive the value of age from the date of birth.

The derived attributes are represented by the dashed oval symbol.