Solved

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

Question 7

Multiple Choice

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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions