Which set of multiplicities correctly shows the relationship between the Cash Receipts table and the Sale table for an organization that allows customers to buy on credit and pay in multiple installments?
A)Cash Receipts (1..1)- Sale (1..1).
B)Cash Receipts (1..N)- Sale (0..N).
C)Cash Receipts (1..1)- Sale (N..M).
D)Cash Receipts (0..N)- Sale (1..1).

Question

Quizplus · Accepted Answer

In this scenario, a single sale can result in multiple cash receipts because customers can pay in multiple installments. However, each cash receipt is linked to exactly one sale. Therefore, for the Sale table, each sale can have multiple associated cash receipts (0..N), indicating that there might be sales not yet paid for. For the Cash Receipts table, each receipt is associated with exactly one sale (1..1), reflecting that every payment is for a specific sale.

Which Set of Multiplicities Correctly Shows the Relationship Between the Cash