Distinguish between a simple attribute, a single-valued attribute, a composite attribute, a multi-valued attribute, and a complex attribute. Develop an example similar to Figure 2.3 that illustrates the difference between each type of attribute?
An attribute that has a discrete factual value and cannot be meaningfully subdivided is called an atomic or simple attribute. A composite attribute, on the other hand, can be meaningfully subdivided into smaller subparts with independent meaning. A single-valued attribute has a single value for a particular entity, whereas a multi-valued attribute can have more than one value for a particular entity. Both simple and composite attributes can be single-valued or multi-valued. A complex attribute is a cluster of composite and multi-valued attributes.