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?
Correct Answer: D
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, is a zero-to-one relationship. This means that for each record in the Order entity, there can be either zero or one record in the Customer entity that is related to it. This implies that the Order entity is optional for the Customer entity, and the Customer entity is mandatory for the Order entity12 References: 1: A Guide to the Entity Relationship Diagram (ERD) - Database Star 2:
Developing an Application - Oracle