Review Figure 2-8 and Figure 2-22. a. Identify any attributes in Figure 2-22 that might...

Review Figure 2-8 and Figure 2-22.

a. Identify any attributes in Figure 2-22 that might be composite attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.

b. Identify any attributes in Figure 2-22 that might be multivalued attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.

c. Is it possible for the same attribute to be both composite and multivalued? If no, justify your answer; if yes, give an example (Hint: Consider the CUSTOMER attributes in Figure 2-22).

Figure 2-8

FIGURE 2-8 Entity with multivalued attribute (Skill) and derived attribute (Years Employed

Figure 2-22