Which method should you use?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *