Review Figure 2-8 and Figure 2-22.

Figure 2-8 

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.

Transcribed Image Text:

EMPLOYEE Employee ID Employee Name(. . .) Payroll Address(...) Date Employed {Skill} [Years Employed] Multivalued Derived Attribute Attribute