Question: There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10
There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-22 described by that point.

SALESPERSON DOES BUSINESS IN TERRITORY PK Salesperson ID Serves + PK Territory ID Salesporson Name Salesperson Telephone Salesperson Fax Territory Name CUSTOMER PRODUCT LINE PK Customer ID PK Product Line ID Customer Name Customer Address Product Line Name Customer Postal Code Submits Includes ORDER PK Order ID Order Date PRODUCT ORDER LINE PK Product ID 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 PK Material ID SUPPLIES PK Work Center ID Material Name Material Standard Cost Work Center Location Supply Unit Price Unit Of Measure Is Supervised By EMPLOYEE WORKS IN Supervises OPK Employee ID HAS SKILL SKILL Employee Name Employee Address PK Skill
Step by Step Solution
3.49 Rating (186 Votes )
There are 3 Steps involved in it
Analysis of Figure 222 a Entities PRODUCT PRODUCT LINE rela... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
613-CS-DB (1593).docx
120 KBs Word File
