Derived attribute in DBMS

April 12, 2021

Derived Attribute in DBMS

In this article, we will learn about Derived Attribute in DBMS.

In some situations, a table need to refer and copy data from another table, derived attribute serves this purpose.

Definition of a derived attribute

A derived attribute data is derived (copied) from the attribute of another table
The derived attribute value is always dynamic.

Example of a derived attribute

If you need to copy the age data from another table to the student table then and age attribute will become derived attribute in the student table

Representation of derived attribute

In the ER diagram, the derived attribute is represented by a dashed oval with a name inside the dashed oval