Multivalued Attribute
- An attribute which can have multiple values is known as a multivalued attribute. Multivalued attributes have multiple values for the single instance of an entity.
- Keu of entity is associated with multiple values. It does not have only one value. It is the opposite of the single-valued attribute.
Example
- Here the student has an attribute named phone_no. One student can have multiple phone_no, so we can say that phone_no can have multiple values.
- These types of attributes are known as multi-valued attributes.
- Multi-valued attributes are used when more than 1 entries for one attribute need to be stored in the Database.
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