A relationship between cash receipt and customer for an enterprise has cardinalities (0,1) cash receipt – (0,N) customer. The enterprise creates a cash receipt table and a customer table to represent the entities. To represent the relationship, the enterprise posts the primary key of the customer entity table into the cash receipt entity table. Why is this considered an implementation compromise, and at what level (conceptual, logical, or physical) is it an implementation compromise?
A minimum of 100 word.