Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette

1. Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric SvendsenShefflette

2. Goals of the Database • Customers can grocery shop online • Keeps track of shipped and unshipped orders • Keeps track of all items at each warehouse

3. Context • Can view available produce at local warehouses • Can view quantity and local prices of produce • Ability to order produce • Can view order history

4. Advantages (ROI) • Grocery shop from home • Can compare prices • Minimize gas consumption

5. Why Use Our Database? • Accessibility • Convenience • Keep track of inventory • Update inventories • Add new items • View current inventories • Model consumer trends

6. Entities • Customers • Orders • Grocery Items • Warehouses • Shipped Orders

7. Tables • Customers • Orders • Grocery Items • Warehouses • Shipped Orders • Order Information

8. Attributes • Prices • Inventory Items • Customer Information • Warehouse, Item and Order IDs

9. Primary Keys • Customer ID • Warehouse ID • Item ID • Order ID

10. Foreign Key • CustID • OrderID • ItemID

11. ER Diagram N N 1 N N 1 N 1

12. Logical Data Model

13. Physical Data Model

17. MangoBanana In Action! • Click Here