Grocery Store Inventory

Continues for 11 more pages »
Read full document

Grocery Store Inventory

By | August 2006
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...
Hide

Rate this document

What do you think about the quality of this document?

Share this document

Let your classmates know about this document and more at Studymode.com