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.
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