Question: Assume you are implementing a database from the preceding diagram. Which of these is the best way to implement the relationship identified by the number

Assume you are implementing a database from the preceding diagram. Which of these is the best way to implement the relationship identified by the number 5?

a. Post the primary key of sales in inventory as a foreign key.

b. Post the primary key of inventory in sales as a foreign key.

c. Create a linking table between sales and inventory.

d. All of these are acceptable.

e. None of these is acceptable.

Inventory Cash 1..1 5 6 0..* Sales ?..? ?..? 3 0.. Cash

Inventory Cash 1..1 5 6 0..* Sales ?..? ?..? 3 0.. Cash Receipts O..* 1.1 2 1..1 1..1 Employees Customers 1.1

Step by Step Solution

3.41 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Accounting Information Systems Questions!