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 3?
a. Post the primary key of customers in sales as a foreign key.
b. Post the primary key of sales in customers as a foreign key.
c. Create a linking table between sales and customers.
d. All of these are acceptable.
e. None of these are acceptable.

Inventory Cash 1..* 1..1 5 6 O..* O..* Sales 7 ?..? ?..?

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

Step by Step Solution

3.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c Create a linking table between sales and customers Explanation The best way t... 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

Students Have Also Explored These Related Accounting Information Systems Questions!