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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
