Review Figure 2-8 and Figure 2-21.
a. Identify any attributes in Figure 2-21 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-21 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 (Consider the CUSTOMER attributes in Figure 2-21).

Transcribed Image Text:

EMPLOYEE Employee ID Employee Name(...) Payroll Address(.. .) Date Employed {Skill} [Years Employed] Multivalued Derived Attribute Attribute Figure 2-8 SALESPERSON TERRITORY DOES BUSINESS IN PK Salesperson ID Serves PK Territory ID Salesperson Name Salesperson Telephone Salesperson Fax Territory Name CUSTOMER PRODUCT LINE PK Product Line ID PK Customer ID Customer Name Product Line Name Customer Address Customer Postal Code Submits Includes ORDER PK Order ID Order Date PRODUCT PK Product ID ORDER LINE Product Description Product Finish Ordered Quantity Product Standard Price VENDOR USES PRODUCED IN PK Vendor ID Vendor Name Goes Into Quantity Vendor Address RAW MATERIAL WORK CENTER SUPPLIES PK Material ID PK Work Center ID Material Name Material Standard Cost Work Center Location Supply Unit Price Unit Of Measure Is Supervised By EMPLOYEE O PK Employee ID WORKS IN Supervises SKILL HAS SKILL He Employee Address Employee Name PK Skill Figure 2-21