taber shimono lilyana gross andrea nelson chelsea ball eric svendsen shefflette
DESCRIPTION
Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette. Goals of the Database. Customers can grocery shop online Keeps track of shipped and unshipped orders Keeps track of all items at each warehouse. Context. Can view available produce at local warehouses - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/1.jpg)
Taber ShimonoLilyana GrossAndrea NelsonChelsea Ball
Eric Svendsen Shefflette
![Page 2: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/2.jpg)
Customers can grocery shop online Keeps track of shipped and unshipped orders Keeps track of all items at each warehouse
Goals of the Database
![Page 3: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/3.jpg)
Can view available produce at local
warehouses Can view quantity and local prices of produce Ability to order produce Can view order history
Context
![Page 4: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/4.jpg)
Grocery shop from home Can compare prices Minimize gas consumption
Advantages (ROI)
![Page 5: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/5.jpg)
Accessibility Convenience Keep track of inventory
Update inventories Add new items View current inventories
Model consumer trends
Why Use Our Database?
![Page 6: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/6.jpg)
Customers Orders Grocery Items Warehouses Shipped Orders
Entities
![Page 7: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/7.jpg)
Customers Orders Grocery Items Warehouses Shipped Orders Order Information
Tables
![Page 8: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/8.jpg)
Prices Inventory Items Customer Information Warehouse, Item and Order IDs
Attributes
![Page 9: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/9.jpg)
Customer ID Warehouse ID Item ID Order ID
Primary Keys
![Page 10: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/10.jpg)
CustID OrderID ItemID
Foreign Key
![Page 11: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/11.jpg)
ER Diagram
N
N
1
NN
N
1
1
![Page 12: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/12.jpg)
Logical Data Model
![Page 13: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/13.jpg)
Physical Data Model
![Page 14: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/14.jpg)
![Page 15: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/15.jpg)
![Page 16: Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette](https://reader035.vdocuments.us/reader035/viewer/2022081520/56816460550346895dd63c99/html5/thumbnails/16.jpg)