What Is a Derived Attribute Give an Example?

What Is a Derived Attribute Give an Example?
A derived attribute is an attribute whose value is calculated from other attributes. It need not be physically stored within the database; rather it can be derived by means of an algorithm. Example: Given attributes of EMPLOYEE entity are EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_DOB and EMP_AGE.

.

Similarly one may ask, what is a derived attribute provide an example?

Derived Attributes: These attributes are derived from other attributes. It can be derived from multiple attributes and also from a separate table. Example: Today's date and age can be derived. Age can be derived by the difference between current date and date of birth.

Secondly, what are derived attributes in DBMS? A derived attribute is an attribute whose value is calculated (derived) from other attributes. The derived attribute need not be physically stored within the database; instead, it can be derived by using an algorithm.

Similarly, what is an example of an attribute?

attribute. Attribute is defined as a quality or characteristic of a person, place or thing. Intelligence, charm and a sense of humor are each an example of an attribute.

What is an attribute explain different types of attributes with examples?

Attributes are properties which describes each member of an entity set. For example, an EMPLOYEE entity may be described by the employee's name, age, address, salary, and job. A particular entity will have a value for each of its attributes and hence forms major part of data stored in database.

Related Question Answers

What are different types of attributes?

Types of attributes in DBMS with example
  • ATOMIC ATTRIBUTE.
  • COMPOSITE ATTRIBUTE.
  • SINGLE VALUED ATTRIBUTE.
  • MULTI VALUED ATTRIBUTE.
  • STORED ATTRIBUTE.
  • DERIVED ATTRIBUTE.
  • NULL VALUED ATTRIBUTE.
  • KEY ATTRIBUTE.

What are the types of attributes?

  • Simple Attributes- Simple attributes are those attributes which can not be divided further.
  • Composite Attributes- Composite attributes are those attributes which are composed of many other simple attributes.
  • Single Valued Attributes-
  • Multi Valued Attributes-
  • Derived Attributes-
  • Key Attributes-
James H. Sterling
Author

James H. Sterling

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.