In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry on the same order. Which of the following entity-relationships describes this situation?
A)The entities Customer and Order have a one to many relationship.
B)The entities Customer and Order have a many to many relationship.
C)The entities Customer and Jewelry Item have a one to many relationship.
D)The entities Order and Jewelry Item have a one to many relationship.
E)The entities Order and Jewelry Item have a many to many relationship.

Question

Quizplus · Accepted Answer

The situation described can be represented by the entities Order and Jewelry Item with a one to many relationship, as a customer can place an order for multiple jewelry items. The Customer entity is not directly related to the type of jewelry ordered, as one customer can place multiple orders for different types of jewelry.

In a Jewelry Store, a Customer Places an Order for a Piece