You are developing a new database. The database contains two tables named SalesOrderDetail and
Product. You need to ensure that all products referenced in the SalesOrderDetail table have a
corresponding record in the Product table.
Which method should you use?
A.
JOIN
B.
DDL trigger
C.
Foreign key constraint
D.
Primary key constraint