Answer Happy

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.