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)?

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

Go to Database glossary page

Go to Database introduction and conceptual modelling 2 mark questions page

 

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