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