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 .. 22 Conversion from ER to Relational Model .. 23 Constraint .. 25 Conversion to Relational Model .. 26 Customers Checkout Checkout Action Items Employees Dependents Store inventory Manages For Sample Relation Instances.
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.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}