Draw an ER diagram for the order-entry database from above information 12.4. use ER diagaram to derive an appropriate set of base relvar definitions.

NOTE : The standard notations of E/R diagram and relational table mapping rules should be followed.

A database used in an order-entry system is to contain information about customer 12.4 and orders. The following information is to be included: s, items, 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 dered and is progressively reduced to zero as partial shipments are made. Again, design a database for this data. As in the previ- ous exercise, state any assumptions you make regarding dependencies. say one nercent or less