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