Programming
Aptitude
Syllabus
Interview Preparation
Interview Exp.
Off Campus
Please login
Prepinsta Prime
Video courses for company/skill based Preparation
Prepinsta Prime
Purchase mock tests for company/skill building
Multivalued Attributes in DBMS
Multivalued Attributes in DBMS
In this article, we will learn about Multivalued Attributes in DBMS.
Attributes define what type of data is stored in a database table for example student table stores details of Student name, roll no, marks, attendance, etc all these details corresponding the properties or attributes of the student table
Some times we need to store one or more values of a single attribute
Multi-valued attribute Definition
A multivalued attribute is capable of storing more than one value in a single attribute i.e nothing but it can hold multiple values for the single attribute.
Example for Multivalued attribute
- In Real world scenario, a person can have more than one phone number hence “phone number attribute” will become a multivalued attribute
- A person may have more than one address .hence address may become a multi-valued attribute
Representation of multivalued attribute
A multivalued attribute is represented using double oval with the name of the attribute inside the oval.
Read more about Attributes:
Login/Signup to comment