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