Design a database for this data.
SQL
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.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)