Question: Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative. List the associative entities in

Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative. List the associative entities in this figure. Why are there so many associative entities in Figure 2-22?

SALESPERSON DOES BUSINESS IN TERRITORY PK Salesperson ID Serves + PK Territory ID Salesporson Name Salesperson Telephone

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.38 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Figure 222 associative entities DOES BUSINESS IN between TERRITORY and CUSTOMER Although this entity ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1597).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!