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 will have a store ID component plus item information. This will allow a manager to see what items a store has, the quantity, and the current dollar value of items in inventory. Page 5 of 88 ... meat, etc. ITEMS is related to CHECKOUT as described above. STORE: ...
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}