5a.     Explain what a composite attribute is. Explain what multi-valued attribute is. Give at least one example of each.

 

Attribute Type

Description

Example

Composite

An Attribute which consists of a fixed number of fields which can be broken down into individual fields

(Separating the fields need not result in a separate table)

Address (Street, City, State, Zip)

Invoice (Order Number, Date)

Multi-Valued

An attribute which consists of a variable number of fields which when broken down will result repeating groups

(Separating the attributes generally results in a separate table)

Skills

Agents

Patients

(all may have a variable number of components)