Preview

Grocery Store Database

Powerful Essays
Open Document
Open Document
2626 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Grocery Store Database
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 the close

You May Also Find These Documents Helpful

  • Good Essays

    A dependable database is required to provide tracking of the scheduled and unscheduled maintenance for their fleet. The development will contain a database with forms, tables, queries, and reports which track maintenance records, inventory of parts, and any purchases from vendors. The entity relationship diagram (ERD) project will reduce down time of each truck in the fleet and guarantee parts availability. The project will also minimize profits loss due to accessibility of trucks, and each hub will be able to access this database. The overall objective is to bring that proposed database to life and allow Huffman Trucking Company to use that database across all of their various locations.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    The Kudler Foods need to design an entity relationship diagram to illustrate what needs to be on the table. A few of the tables could be combined to make reading the tables much easier. Kudler foods could combine inventory/order relationship, for example; order/sale relationship table, inventory/sale relationship table, and sale/receive payment relationship table. By combining any one of these tables Kudler Foods could process orders faster, find information faster by having the data in order and labeled and overall making the company’s system more efficient. One table Kudler Foods does not have that the management should consider which would benefit the business is an “employee table”. This way; Kudler could have personal information, sales numbers, last date he/she was reviewed, and just able to keep up…

    • 4521 Words
    • 87 Pages
    Satisfactory Essays
  • Good Essays

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    The project should take no longer then five weeks. estimate! If more time is needed, a request will be submitted within the first two weeks. good. The life cycle of the database depends on the growth and needs of Huffman Trucking Company. A yearly analysis will be preformed to determine necessary enhancements over the next three years and will be included in the support cost. Good precaution.…

    • 3219 Words
    • 13 Pages
    Better Essays
  • Powerful Essays

    The purpose of this group assignment is to collaborate as a team to compare different inventory systems and describe the advantage and disadvantages of each system in comparison to the others. Management of inventory is important to any business that wants to succeed. Companies purchase inventory systems to help manage the inventory of an organization. Team A reviewed the following companies and their inventory management programs: Best Buy, , and . This Inventory System Summary includes a description of the chosen companies and their inventory systems, and a comparison describing the advantages and disadvantages of each system. Best Buy…

    • 2054 Words
    • 59 Pages
    Powerful Essays
  • Powerful Essays

    Riordan Manufacturing has requested assistance to provide specific recommendations for improving their inventory system. The objective for this service request is to analyze the current processes in inventory and define business requirements for system upgrades and improvements. Business requirements were established using a set of metrics to evaluate three options for improving inventory practices at Riordan. The three options evaluated are Enterprise Resource Planning system (ERP), Materials Requirements Planning (MRP), and Vender Managed Inventory (VMI). The metrics allowed the three systems to be scored based on the priority of business requirements, which provided the basis for recommendations to Riordan. In addition to using a metrics table to evaluate the three systems, the evaluation team utilized a Gantt chart to develop implementation timelines for project management, assessment, hardware/software installation, user training, and software support. Riordan Manufacturing advised the consulting team of their constraints of a one million dollar budget with a one year implementation deadline. The team also completed an analysis of the return on investment (ROI) for the MRP solution. This analysis proved that the MRP solution would greatly reduce inventory costs for Riordan. Taking into account the business requirements and parameters set by Riordan, the consulting team can make a recommendation.…

    • 3263 Words
    • 14 Pages
    Powerful Essays
  • Good Essays

    Databases play a role for the implementation of industry specific software for users and customers of Kudler Fine Foods. The use cases provided information on how data is readily available for use in reporting or forecasting future business. A relational database would be beneficial to the organization as it “…is usually designed with a number of related tables” (Rainer & Turban, 2008, p. 111). The tables are set up to give the user information on relational data from several accounting departments within the…

    • 757 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Paper

    • 552 Words
    • 3 Pages

    Kudler Fine Foods business thrives on quality of inventory product. It is essential to establish the proper guidelines to track and store inventory. If not followed properly Kudler's Food can be tainted and perish away in storage. Kudler's Fine Food can't allow this process to be overlook and infect the Fine Food Brand. This paper will evaluate the design elements from an accounting perspective of the data tables. With the existing data tables a entity relationship diagram will be illustrated. Also, recommendations will be addressed to improve the data tables. Finally, an example pivot table will be demonstrated to help improve decision making for management.…

    • 552 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Thank you for the opportunity to provide a proposal for implementing a new Inventory System Process for Riordan Manufacturing.…

    • 2021 Words
    • 9 Pages
    Better Essays
  • Powerful Essays

    The US retail grocery industry includes about 65,000 supermarkets and other grocery stores with combined annual revenue of about $550 billion. Key growth drivers are consumer spending habits and food trends (Blank, 2014). Over the past twenty years, the traditional supermarket has been shaped and reshaped to try and meet consumer demands. Recently, generation Y has begun to push its impression on supermarkets looking for a fresh market and whole foods market approach that bring more natural, organic, and specialty foods to the forefront. Population growth and consumer tastes drive demand. Large corporations can offer a widespread selection of foods and have the edge in purchasing, large distribution channels, marketing dollars, and financial backing. Small companies must…

    • 1247 Words
    • 5 Pages
    Powerful Essays
  • Best Essays

    The selected database I have chosen for this project will be that of a veterinary medical supply database and the veterinarians who order medications from that database. I will track what is ordered and shipped to the veterinarians. This is an online veterinary supply, so, all medications will be mailed (or shipped) to the customer with a…

    • 3587 Words
    • 15 Pages
    Best Essays
  • Good Essays

    Database systems are a way to collect and store large amounts of data. Essentially, database are electronic filing systems that store raw data to be later retrieved as useable information (Skillport, ). Using such a tool simplifies the filing and storage of all sorts of information used by businesses today. A common type of database is a customer/inventory database. Different tables store customer information, past customer orders, inventory counts and distributor information and then this information can be cross-referenced for following inventory pathways.…

    • 666 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Kudler Fine Foods is a fast growing company established in 1998 and their Initial store selected Microsoft Access as the database to track inventory, sales, orders, employees, and customers. Kudler’s products are perishable and inventory must be properly tracked. This paper will evaluate database tables from accounting perspective, and provide recommendations for improvement. Pivot Table and Entity Relationship diagram will help Kudler’s to build better decision-making process.…

    • 565 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    /*List the product details including UPC code, manufacturer, MSRP, product description, and category id for Chick Breast and Whole Chicken*/…

    • 2297 Words
    • 10 Pages
    Satisfactory Essays