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