The attributes that are not present in the whole DBMS but can be formed using other attributes are known as "Derived Attributes".

Derived attributes are attributes whose values are calculated from other attributes. These attributes do not exist in the physical database, but their values can be derived using existing attributes from the database.

For example, in a database containing information about employees, there might be attributes like 'Date of Birth' and 'Date of Joining'. A derived attribute could be 'Age' or 'Years of Service', which can be calculated from the 'Date of Birth' and 'Date of Joining' attributes respectively.

So, the steps to form a derived attribute are:

1. Identify the attributes from which the derived attribute can be calculated.
2. Define the calculation or formula that will be used to derive the new attribute.
3. Implement this calculation or formula in the database system, so that the derived attribute can be calculated when needed.

Remember, the derived attribute is not stored in the database, but is calculated on-the-fly when required.

Question

The attributes that are not present in the whole DBMS but can be formed using other attributes are known as "Derived Attributes".

Derived attributes are attributes whose values are calculated from other attributes. These attributes do not exist in the physical database, but their values can be derived using existing attributes from the database.

For example, in a database containing information about employees, there might be attributes like 'Date of Birth' and 'Date of Joining'. A derived attribute could be 'Age' or 'Years of Service', which can be calculated from the 'Date of Birth' and 'Date of Joining' attributes respectively.

So, the steps to form a derived attribute are:

1. Identify the attributes from which the derived attribute can be calculated.
2. Define the calculation or formula that will be used to derive the new attribute.
3. Implement this calculation or formula in the database system, so that the derived attribute can be calculated when needed.

Remember, the derived attribute is not stored in the database, but is calculated on-the-fly when required.

Knowee AI · Accepted Answer

The attributes that are not present in the whole DBMS but can be formed using other attributes are known as "Derived Attributes".

Derived attributes are attributes whose values are calculated from other attributes. These attributes do not exist in the physical database, but their values can be derived using existing attributes from the database.

For example, in a database containing information about employees, there might be attributes like 'Date of Birth' and 'Date of Joining'. A derived attribute could be 'Age' or 'Years of Service', which can be calculated from the 'Date of Birth' and 'Date of Joining' attributes respectively.

So, the steps to form a derived attribute are:

1. Identify the attributes from which the derived attribute can be calculated.
2. Define the calculation or formula that will be used to derive the new attribute.
3. Implement this calculation or formula in the database system, so that the derived attribute can be calculated when needed.

Remember, the derived attribute is not stored in the database, but is calculated on-the-fly when required.

Attributes that are not present in the whole DBMS but can be formed using other attributes are

Question

Solution

Similar Questions

Upgrade your grade with Knowee