Question :: Composite Vs. Multi Valued Attributes
Answer:
Composite :
Composite attributes can be divided into subparts. For example, an attribute name
could be structured as a composite attribute consisting of first-name, middle-initial,
and last-name.
Multivalued:
There may be instances where an attribute has a set of values for a specific
entity. Consider an employee entity set with the attribute phone-number. An
employee may have zero, one, or several phone numbers, and different employees
may have different numbers of phones. This type of attribute is said to be
Composite Attributes : Attribute Divided into sub parts. Eg. Name (First name,
Middle Name, last name)
Multivalued Attributes : Attribute having more than one values. Eg. Phone
Number.
