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