Transcription of Grocery Store Project
{{id}} {{{paragraph}}}
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. 4 Project & Database scope .. 7 Entity Set Description .. 8 Customers Dependants Employees Checkout Items Store inventory Checkout Actions Relationship Set Description .. 18 Related Entity Set .. 20 ER Diagram .. 21 Phase II: From ER (Conceptual) Model to Relational (Logical) Model ER Model and Relational Model Description.
inventory. Management reports needed for management will have to answer questions including the current status of inventory quantity per store, price per item, customer activity, and sales totals. Managers can query employee information like wage information, store worked, dependents and manager. Inventory report(s) will include
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}