You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in
the Salesperson table.
Which database object should you add to the Sales table?
A.
Nonclustered index
B.
Primary key
C.
Foreign key
D.
Clustered index
C. Foreign Key. The Sales table would need the SalespersonID field from the Salesperson table. This would be a reference key (foreign key) to the Salesperson table.
Agreed with Anony 🙂
Awnser is Foreign key.
The foreign key constraint checks to see if the data is valid.
C
AGREE THIS IS C