You Are Given an E-R Diagram with Two Entities,ORDER and CUSTOMER,as

question 38

Multiple Choice

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place many orders and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?

• A)0:1
• B)1:1
• C)1:N
• D)N:1
• E)N:M

---

Definitions:

Optimal Quantity

Optimal quantity is the most efficient amount of goods or resources needed to minimize costs and maximize value or profitability.

Wholesale Price

Wholesale Price is the cost of goods sold in large quantities for the purpose of resale by retailers, often lower than the retail price to allow for margins.

Retailer

A business or person that sells goods directly to consumers.

Manufacturer

An entity that produces finished goods from raw materials on a large scale, using machinery, labor, and production processes.