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

Question

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

Quizplus · Accepted Answer

The Employees table should include a primary key column for Employee ID. The Sales Orders table should include a primary key column for Sales Order ID. The relationship between these two tables is that each Sales Order is associated with one Employee, but each Employee may be associated with many Sales Orders. Therefore, the Sales Orders table should include a foreign key column for Employee ID, which references the primary key column of the Employees table. This creates a one-to-many relationship between Employees and Sales Orders.

Consider the Following Diagram