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) Valid “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), each giving item number, quantity ordered – For each item: Item number (unique) Warehouses Quantity on hand at each warehouse 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.] Design a database for this data.
A
For each customer: Customer number (unique) Valid “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), each giving item number, quantity ordered –
For each item: Item number (unique) Warehouses Quantity on hand at each warehouse 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.]
Design a database for this data.
note :
You were asked to convert the given ERD into relations and implement it into mysql workbench.
Step by step
Solved in 2 steps with 2 images
