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.

---

Definitions:

Drainage Divide

The boundary between adjacent drainage basins.

Drainage Basin

The area of land drained by a river and its tributaries, also known as a watershed or catchment area.

High Ground

An area of elevated terrain that can provide strategic advantages, such as better visibility or defense, and is often sought after in military and construction contexts.

Tributaries

Streams or rivers that flow into a larger body of water, such as a larger river, lake, or ocean.