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

question 34

Multiple Choice

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.