Stored Attribute
- If the data of the attribute remains constant for every instance of entity then it is called a Stored Attribute.
- The value of the attribute present in the database does not get updated and it remains constant once it is stored.
- These attributes are used to store permanent information about an entity which will remain constant throughout the lifetime of the entity.
Example
- The student has 3 attributes as shown above. Her name and DOB will remain the same throughout his/her education. So the student has a fixed value attribute that will never change in the future.
- These attributes are known as stored attributes.
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