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.

Transcribed Image Text:

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