Question: There is a bulleted list associated with Figure 2-21 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-21 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-21 described by that point.

SALESPERSON TERRITORY DOES BUSINESS IN PK Salesperson ID Serves PK Territory ID Salesperson 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 PK Product ID Product Description Product Finish Product Standard Price ORDER LINE Ordered Quantity VENDOR USES PRODUCED IN PK Vendor ID Vendor Name Goes Into Quantity Vendor Address RAW MATERIAL PK Material ID WORK CENTER SUPPLIES PK| Work Center ID Material Name Material Standard Cost Unit Of Measure Work Center Location Supply Unit Price Is Supervised By EMPLOYEE WORKS IN Supervises O PK Employee ID HAS SKILL SKILL Employee Name Employee Address PK Skill
Step by Step Solution
3.34 Rating (154 Votes )
There are 3 Steps involved in it
1 Entities PRODUCT PRODUCT LINE relationship Includes 2 ... View full answer
Get step-by-step solutions from verified subject matter experts
