Page 1 of 12

Grocery Store Inventory

Continues for 11 more pages »
Read full document

Grocery Store Inventory

Page 1 of 12
Grocery Store Inventory System
Abstract
In this paper, Learning Team B will describe a grocery store inventory system for Florida Food Mart, which includes information about the ordering, delivery, and stocking of items in a grocery store. Included within the paper is an Entity-Relationship Diagram (ERD), which is a comprehensive breakdown of the different entities and relationships within the grocery store inventory system. The intention of this paper is to provide the reader with enough information to conduct a thorough assessment of the inventory system. Learning Team B has provided a scope of the project as well as the mission statement used in order to accomplish its goals. Provided within the paper are the business rules, entity-relationship diagram and the data fields.

Introduction
Florida Food Mart is a medium size grocery store located in Tampa, Florida. The store and management offices are housed in a 20,000 square foot facility on the North West side of Tampa. There are approximately 45 employees consisting of 20 Cashiers, 10 Stock Clerks, 8 Bagging Associates, 3 Shipping and Receiving Clerks, 3 Store Managers, 1 Technician, 2 Purchasing Agents, 1 Accountant, 1 Marketing Director, 1 Vice President, and 1 President.

Learning Team B has been assigned the task of upgrading Florida Food Mart's outdated inventory processing system by designing and implementing a state of the art relational database management system utilizing MS Access integrated with Florida Food Marts present point-of-sale (POS) software.

Learning Team B has agreed to have a fully functional system in place by December 1, 2002. A preliminary budget of $75,000.00 has been approved and allocated to this project. Scope
The Learning Team B proactively worked on the development of the Entity Relationship Diagram (ERD). The ERD is being designed as a management tool to assist with the development of the Team's Grocery Store Inventory System. The Grocery Store Inventory System...