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.
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)