1 / 17

Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette

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

avent
Download Presentation

Taber Shimono Lilyana Gross Andrea Nelson Chelsea Ball Eric Svendsen Shefflette

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

  14. MangoBanana In Action! • Click Here

More Related