Among the E-R models shown below, which one depicts a simplified E-R model for the following scenario?

An online retailer of coffee beans maintains a long list of unique coffee flavors. The company purchases beans from several suppliers; however, each coffee flavor (each product) is purchased from only a single supplier. Many customers are repeat purchasers and typically order at least five flavors of beans per order.

Question

Among the E-R models shown below, which one depicts a simplified E-R model for the following scenario?

An online retailer of coffee beans maintains a long list of unique coffee flavors. The company purchases beans from several suppliers; however, each coffee flavor (each product) is purchased from only a single supplier. Many customers are repeat purchasers and typically order at least five flavors of beans per order.

BlackTom AI · Accepted Answer

Let me restate what the scenario requires and then evaluate the typical E-R mappings you’d expect to see in the options.

- There are Suppliers and Products (Flavors). Each product (flavor) is purchased from only a single supplier. This implies a many-to-one relationship from Products to Suppliers (many flavors can come from one supplier, but each flavor comes from exactly one supplier).
- The retailer has Customers who place Orders. A customer can place many orders over time. So there is a one-to-many relationship from Customers to Orders.
- Each Order contains multiple items (Order Items), and each item corresponds to a specific Product (Flavor). This creates a many-to-many relationship between Orders and Products, which is typically implemented with an associative entity called Order Items (often including quantity of each flavor per order).
- The overall design should show the path: Suppliers -> Products (Flavor) -> Order Items -> Orders -> Customers, with Order Items acting as the bridge between Orders and Products.

Now, to analyze the options (note: the provided answer options are empty in your prompt, so I’ll describe how to judge each option if they were visible):
- Option depicting Suppliers connected to Products (Flavor) with a direct line, then Products to Order Items, Order Items to Orders, and Orders to Customers, where the connection from Products to Suppliers is many-to-one (many flavors from one supplier) is correct. The presence of an Order Items entity between Orders and Products confirms the many-to-many relationship between Orders and Products is implemented properly.
- Option that shows a direct, unmediated link between Orders and Products (without an Order Items associative entity) would be incorrect for representing multiple flavors per single order, since you need a junction to store multiple line items (flavor and quantity) per order.
- Option that reverses the direction incorrectly (for example, linking Orders to Customers before connecting Orders to Order Items and Products) would fail to capture that each order is placed by one customer but can include multiple flavors, and that each flavor comes from a single supplier.
- Option that shows a many-to-many relationship directly between Suppliers and Orders or between Customers and Products without the junction table would be incorrect, as it would not accurately model the one-to-many from Suppliers to Products or the itemized nature of an order containing multiple flavors.

In summary, the correct diagram should illustrate:
- A one-to-many relationship: Suppliers -> Products (Flavors) with every flavor tied to exactly one supplier.
- A many-to-many relationship between Orders and Products implemented via an associative entity Order Items, which records each flavor in an order (and typically quantity).
- A one-to-many relationship: Customers -> Orders, showing that a single customer can place multiple orders over time.

If you can share the exact visuals or the text labels of the four options, I can map the reasoning to each option line by line and identify the correct one precisely.

BU.330.770.T2.FA25 Final Exam- Requires Respondus LockDown Browser

查看解析

登录即可查看完整答案

类似问题

Use of a supertype/subtype relationship is necessary when which of the following exists?

Using the Entity Relationship Diagram you have drawn on your piece of paper for the Final Subjects Results Table answer the following question. Which relationship should be drawn between the Results and Lecturers entities for the Final Subjects Results Table?

Which of the following statements is true regarding relationships in an ERD?

Observe the ER diagram for the CENTRAL SCHOOL LIBRARY Which of the following is NOT true according to the Central School Library ER diagram?

ER Modelling A Assuming that common sense applies, which one of the following ER model fragments is most believable?

According to this E/R diagram, which of the following is an entity type? Select one answer.

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单