Key Attribute
- The attribute which has unique values for every row in the table is known as a Key Attribute. The key attribute has a very crucial role in the database.
- The key attribute is a distinct and unique characteristic of the entity that can be used to identify the entity uniquely.
Example
- For students, we can identify every student with roll_no because each student will have a unique roll_no.
- This indicates that roll_no will be a Key attribute for the Student entity.
- All operations on the database can be performed only using Key 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