Derived Attribute
- The attribute that can be derived from the other attributes and does not require to be already present in the database is called a Derived Attribute.
- Derived attributes are not stored in the Database directly. It is calculated by using the stored attributes in the database.
Example
- Here the student has multiple attributes including DOB and age. It is observed that age can be calculated with the help of the DOB attribute.
- So age is a derived attribute that is derived from an attribute named DOB.
Attributes in DBMS
Attributes are properties or characteristics of an entity. Attributes are used to describe the entity. The attribute is nothing but a piece of data that gives more information about the entity. Attributes are used to distinguish one entity from the other entity. Attributes help to categorize the entity and the entity can be easily retrieved and manipulate the entity. Attributes can help the database to be more structural and hierarchical. An entity with no attribute is of no use in the database.
Contact Us