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?

A. The Sales Order ID will be included as a foreign key in the Cash Receipts table
B. A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key
C. The Cash Receipt ID will be included as a foreign key in the Sales Orders table
D. The Cash Receipt Amount field will be included as a foreign key in the Cash Receipts table

Question

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?
  
A. The Sales Order ID will be included as a foreign key in the Cash Receipts table
B. A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key
C. The Cash Receipt ID will be included as a foreign key in the Sales Orders table
D. The Cash Receipt Amount field will be included as a foreign key in the Cash Receipts table

Quizplus · Accepted Answer

The Answer of 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?
  
A. The Sales Order ID will be included as a foreign key in the Cash Receipts table
B. A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key
C. The Cash Receipt ID will be included as a foreign key in the Sales Orders table
D. The Cash Receipt Amount field will be included as a foreign key in the Cash Receipts table

Consider the Following Diagram