Grocery Store Database

Database design , Accounts payable , Entity–relationship model

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.

The Database Team 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.

The Database Team 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 Database Team 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 is to be utilized by four main sections: purchasing agent's ordering merchandise, merchandise being received and placed in storage, customer purchasing merchandise, and accounting paying invoices and calculating profit and losses. Learning Team B has established the following methodology that will be followed throughout the project. ·Establish a scope of work

·Analysis of current system
·Analysis of future system
·Cost analysis
·Requirements documentation
·Database Entity-Relationship model
·Detail design of database system
·Testing
·Implementation
·Maintenance
Purpose
The purpose of the grocery inventory system is to track inventories, sales, and the calculation of profits and losses to effectively manage a grocery store. This inventory system will allow for...
tracking img