Certificate in Business Data Analytics (CBDA) — Question 65

What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order?

Answer options

• A. one-to-many
• B. zero-to-one
• C. many-to-many
• D. one-to-one

Correct answer: A

Explanation

The correct answer is A, one-to-many, because a single customer can place multiple orders, but each order is linked to only one customer. Options B (zero-to-one) and D (one-to-one) do not accurately reflect the possibility of multiple orders by a single customer. Option C (many-to-many) is incorrect as it implies that customers and orders can exist independently of each other, which contradicts the given condition.