Derived attribute in DBMS

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.

Derived Attribute in DBMS

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