What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

A)Commission Rate
B)First Name
C)Sales Person ID
D)Price

Question

What is the best option for a field to build a relationship between the tables Sales Personnel and Orders with the following fields?

A)Commission Rate 
B)First Name 
C)Sales Person ID 
D)Price

Quizplus · Accepted Answer

The Sales Person ID field would likely be the best choice as it would serve as a primary key in the Sales Personnel table and a foreign key in the Orders table, connecting the two tables and allowing for the tracking of sales made by each individual sales person. The other fields (Commission Rate, First Name, and Price) do not provide a direct link between the two tables.

What Is the Best Option for a Field to Build