Consider the Following Diagram

question 19

Short Answer

Consider the following diagram. Which of the following best describes how the relationship between Sales Orders and Cash Receipts will be implemented in the resulting database?

A. The Sales Order ID will be included as a foreign key in the Cash Receipts table
B. A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key
C. The Cash Receipt ID will be included as a foreign key in the Sales Orders table
D. The Cash Receipt Amount field will be included as a foreign key in the Cash Receipts table

---

Definitions:

Mate Choice

The process by which an individual selects a partner based on certain traits or behaviors that are indicative of high genetic quality or compatibility.

Female Fruit Flies

Refers to the female specimens of fruit flies, often studied for genetics, behavior, and evolutionary biology.

Sperm-Transferring Pedipalps

In certain arachnids, modified appendages used by males to transfer sperm to the female during reproduction.

Male Spider

A reference to the male of the spider species, which often engages in complex mating rituals and sometimes faces post-mating cannibalism by the female.