Grocery Store Project

← Back to document page

Grocery Store Project CMPS 342 Christian Trahan Brandon Jones Page 2 of 88 DATABASE SYSTEMS Project Table of Contents Phase I: Fact-Finding, Information Gathering and Conceptual Database Design Fact Finding Techniques and Information Gathering ........................................ ........................ 4 Data gathering, operations on data, and reports ........................................ ................................. 5 Introduction to Enterprise/Organization ........................................ ........................................ ..... 6 1. 4Project & Database scope ........................................ ........................................ ........................... 7 Entity Set Description ........................................ ........................................ ................................ 8 Customers Dependants Employees Checkout Items Store inventory Checkout Actions Relationship Set Description.

Inventory report(s) will include quantity in each store and the value of the current inventory. The report will have a ‘restock’ button that will be used to reset all inventory items to a preset quantity and date so a user can simulate purchasing items multiple times. In the real world the store would order more inventory from their warehouse.

  Order, Inventory