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.
CUSTOMER: This entity type represents all the people that shop at the grocery store. A customer performs a checkout. The CUSTOMER entity relates to the CHECKOUT table via the BUY ITEM relationship. The Cust_ID primary key is a foreign key in the checkout table. EMPLOYEES: This entity type represents all the people that work for the grocery ...
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}