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.