Single Valued Attribute
- The attribute with only a single value is known as a single-valued attribute. These attributes have a single value for each instance of a given entity.
- Mostly these attributes are used to provide the unique identity to the multiple instances of attributes.
Example
- In the given example, we know that the DOB attribute will have only one value. So we can say that the DOB attribute is nothing but a single Valed attribute and it cannot have multiple attributes.
- Here roll_no and name will also have mostly one value only.
- We can say that all 3 attributes of the student are single-valued.
Single valued attribute
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.