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

Sales Person ID is the best option because it is a unique identifier for each salesperson and can be used to link their sales orders to them accurately. Commission Rate is specific to each salesperson, but it may vary over time or with different products, making it less reliable for building a relationship between the two tables. First Name and Price are not relevant to building a relationship between the two tables.

What Is the Best Option for a Field to Build