Suppose a Products table has a ProductID primary key,and a related Sales table has a ProductID foreign key.Which of the following would cause a concern?
A)The Sales table has several records with ProductID 79,and the Products table has exactly one record with ProductID 79.
B)The Products table has exactly one record with ProductID 43,and the Sales table has no records with ProductID 43.
C)The Sales table has several records with ProductID 61,and the Products table has no records with ProductID 61.
D)The Products table has exactly one record with ProductID 87,and the Sales table has only one record with ProductID 87.

Question

Quizplus · Accepted Answer

Option C is a concern because it indicates that there are sales records for a product that does not exist in the Products table, which violates referential integrity.

Suppose a Products Table Has a ProductID Primary Key,and a Related