Consider the following diagram.How will the database relationship between Customers and Sales Orders be implemented?
A)The Sales Order ID will be included as a foreign key in the Customers table.
B)The Customer ID will be included as a foreign key in the Sales Orders table.
C)The Customer ID will be included as a primary key in the Customer table.
D)The Sales Order ID will be included as a primary key in the Customer table.

Question

Consider the following diagram.How will the database relationship between Customers and Sales Orders be implemented? 
A)The Sales Order ID will be included as a foreign key in the Customers table. 
B)The Customer ID will be included as a foreign key in the Sales Orders table. 
C)The Customer ID will be included as a primary key in the Customer table. 
D)The Sales Order ID will be included as a primary key in the Customer table.

Quizplus · Accepted Answer

The relationship between Customers and Sales Orders is a one-to-many relationship, as each customer may have multiple sales orders. Therefore, the foreign key (Customer ID) should be included in the Sales Orders table to link each order to the corresponding customer.

Consider the Following Diagram