Consider The Following Diagram Which Of The Following Best Describes How The Relationship Between Sales Orders And Cash 1 (31.9 KiB) Viewed 23 times
Consider the following diagram. Which of the following best describes how the relationship between Sales Orders and Cash Receipts will be implemented in the resulting database? Products Cash 1..* 1..1 0.." 0..* 1.. Sales Orders 0..* 0..* Cash Receipts 0..* 0..* 0..* 1..1 1..1 Employees 1..1 Customers. 1..1
O O O O The Cash Receipt Amount field will be included as a foreign key in the Cash Receipts table. A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key. The Sales Order ID will be included as a foreign key in the Cash Receipts table. The Cash Receipt ID will be included as a foreign key in the Sales Orders table.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!