ER Diagram

Develop an ER diagram for the following:



A database used in an order-entry system is to contain information about
customers, items, and orders. The following information is to be
included:



· For each customer:

Customer number (unique)

“Ship-to� addresses (several per customer)

Balance

Credit Limit

Discount



· For each order:

Heading information

Customer number

Ship-to address

Date of Order



· Detail lines (several per order):

Item Number

Quantity ordered



· For each item:

Item number (unique)

Manufacturing plants

Quantity on hand at each plant

Stock danger level for each plant

Item description



For internal processing reasons, a “quantity outstanding� value is
associated with each detail line of each order; this value is initially
set equal to the quantity of the item ordered and is progressively
reduced to zero as partial shipments are made. Again, design a database
for this data. State assumptions you make regarding dependencies.