Sunday, 11 February 2018

Single valued and multi-valued attributes

Single valued attribute and Multi-valued attribute


Single valued attributes: attributes with a single value for a particular entity are called single valued attributes. For example, in the following table Emp_ID is a single valued attribute as each entity in the following table has only one value for Emp_ID attribute.


Emp_NO
Name
Age
Phone
E102
Mariappan
35
9898767654
E110
Sruthi
30
7867564500
E016
Kesavan
25
9090808070, 7867799070
E230
Suresh
45

E567
Stella
38
9045565388

Which other attribute(s) could be single valued attribute(s)?

Multi-valued attributes: Attributes with a set of values for a particular entity are called multi-valued attributes. For example, in the above table Phone_No is the multi-valued attribute as each entity can have zero/one or more phone numbers.


Which other attribute(s) could be multi-valued attribute(s)?

**************




 
What is single-valued attribute
what is multi-valued attribute
define single valued and multi valued attributes
give examples for single valued attributes
give examples for multi-valued attributes
why we have single and multi-valued attributes
 







No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...