Data Models/Systems Analysis

Grocery List App

Download data model (MySQL Workbench file) · View data model (PNG image) · View representative queries (Microsoft Word document)

This was Project I in my Database Management class. For this project, I worked with two other classmates. We worked together on creating the data model, and we split the queries and sample data entry evenly among ourselves.

The premise of this assignment was to create the database behind a future iPhone grocery list app. With a network of participating stores, this app would hook into their inventory systems and allow customers to see products, prices, and locations within the store. With that knowledge, they would be able to plan their shopping trips more effectively. Coupons could also be included in the database. The queries, listed in the report document, were intended to represent some real-world uses of the app, from both the shopper's perspective and the store personnel's perspective.