Grocery Store Database

Topics: SQL, Entity-relationship model, Relational model Pages: 12 (2626 words) Published: November 21, 2005
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
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 the close monitoring of many different aspects of the inventory process including shipping, receiving, and invoicing. This will, in turn, allow the grocery store to take a more active role in the inventory process, which will allow employees to become more effective and productive due to this automation. We feel that with this grocery store inventory system it will allow for the increased efficiency, increased productivity and increased accountability in the inventory process. Assumptions

In addition to the business rules that constrain the design of the inventory system, the design team has made several assumptions regarding the functionality and implementation of the inventory system. The inventory system will use the vendor file currently maintained and used by accounting for the payment of invoices. The invoicing process will be integrated with the existing payables process. The current POS equipment will provide the sales receipt transactions to the inventory system. Every invoice from a vendor will reference the PO number and associate the invoice line items with the PO line items. Every receipt from a vendor will reference the PO number and associate the invoice line items with the PO line items. Items that are received will be properly received against the PO, line item that they were ordered against. No additional computing hardware or infrastructure will be necessary since existing computer systems and the placement of those systems is sufficient to support the inventory project. Microsoft Access, which is currently being used to provide accounting support, will be used for the inventory system. The personnel currently involved in the manual processing of the inventory function will be retrained to support the automated inventory system. The automated input process will reduce the time needed to process purchase orders and receipts. The discovered business rules will remain in force throughout the design and implementation of the project, which will allow...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Gourmet Grocery Stores: Eating Healthy Is Expensive Essay
  • Grocery Gateway Essay
  • H.E.B. Grocery Essay
  • Peapod: Online Grocery Shopping Essay
  • Grocery Gateway Essay
  • Walmart
  • Essay about Grocery Retail Market Analysis
  • C&C Grocery Essay

Become a StudyMode Member

Sign Up - It's Free