• 
  Using Visio or another modeling tool of your choice, reproduce the diagram from your Modern Database Management
• 

Transcribed Image Text:

SALESPERSON PK Salesperson ID Salesperson LName Salesperson MI Salesperson FName Salesperson Telephone Salesperson Fax (b) Suggested Visio Solution (Multivalued Attributes) PRODUCT FINISH PK Product Finish PK Product ID Product Standard Price Provided In VENDOR PK Vendor ID SKILL PK Skill Vendor Name Vendor Street Vendor City Vendor State Vendor Zip Supplies Supply Unit Price DO TH HAS SKILL Serves -H-- H TERRITORY PK Territory ID Note: CUSTOMER entity may also have multivalued attributes for Address (e.g., ShipTo, Bill To) PRODUCT LINE PK Product Line ID Product Line Name = A PRODUCT -HPK Product ID USES Territory Name Product Description Goes Into Quantity RAW MATERIAL Includes PK Material ID Is Supervised By Material Name Standard Cost Unit Of Measure -O+ OPK Supervises # HH H EMPLOYEE Employee ID Employee LName Employee MI Employee FName H Employee Street Employee City Employee State Employee Zip DOES BUSINESS IN POH CUSTOMER PK Customer ID Customer Name Customer Street Customer City Customer State Customer Postal Code Submits ORDER PK Order ID PRODUCED IN Order Date Customer ID ORDER LINE Ordered Quantity Product ID WORK CENTER PK Work Center ID Work Center Location WORKS IN SALESPERSON PK Salesperson ID Salesperson LName Salesperson MI Salesperson FName Salesperson Telephone Salesperson Fax (b) Suggested Visio Solution (Multivalued Attributes) PRODUCT FINISH PK Product Finish PK Product ID Product Standard Price Provided In VENDOR PK Vendor ID SKILL PK Skill Vendor Name Vendor Street Vendor City Vendor State Vendor Zip Supplies Supply Unit Price DO TH HAS SKILL Serves -H-- H TERRITORY PK Territory ID Note: CUSTOMER entity may also have multivalued attributes for Address (e.g., ShipTo, Bill To) PRODUCT LINE PK Product Line ID Product Line Name = A PRODUCT -HPK Product ID USES Territory Name Product Description Goes Into Quantity RAW MATERIAL Includes PK Material ID Is Supervised By Material Name Standard Cost Unit Of Measure -O+ OPK Supervises # HH H EMPLOYEE Employee ID Employee LName Employee MI Employee FName H Employee Street Employee City Employee State Employee Zip DOES BUSINESS IN POH CUSTOMER PK Customer ID Customer Name Customer Street Customer City Customer State Customer Postal Code Submits ORDER PK Order ID PRODUCED IN Order Date Customer ID ORDER LINE Ordered Quantity Product ID WORK CENTER PK Work Center ID Work Center Location WORKS IN

Answer rating: 100% (QA)

Warehouse warehouse D warehousename warehouse location Manufacturer manufa... View the full answer