Kudler Fine Foods Database Analysis Essay - 1763 Words

Kudler Fine Foods Database Analysis Overview Kudler Fines Foods is a rapidly growing small business located in Southern California. Founded in 1998, Kudler specializes in providing quality gourmet foods to a wide range of customers. When Kudler opened its first store back in 1998, Microsoft Access was chosen as the database platform used to track inventory, orders and customers. While this initially proved to be an adequate solution, it has since outgrown its usefulness. Now with three stores and a fourth due to open soon, a new database management system must be put into place. One of the most detrimental problems with the Microsoft Access database is that it is limited to a file size of only two gigabytes. While this may†¦show more content†¦The Inventory table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc. Each record in the inventory table is linked to the Item table by the item_id and to the Supplier’s table by the supplier_id. The Item table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store. The Item table is linked to the Inventory table by way of the item_id and to the Order Line table by the item_id field. The Order table is used to record information pertinent to each order placed with a given store. Each order will have one or more entries in the Order Line table associated with it. The Order table is linked to the Order Line table by the store_code and the order_id. It also links to the Customer table via the customer_id field. The Order Line table contains details on items appearing on an order. One or more order lines are associated with each order and each order line references an item being purchased with its description, quantity, price, etc. The Order Line table is linked with the Order table by the order_id and the store_code. It also links to the Item table by the item_id. The Store table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc. TheShow MoreRelatedBsa 310 Kudler Frequent Shopper Program1557 Words   |  7 PagesKudler Fine Foods is a much renowned food store, established at the different locations in California. The main focus of the store is to have ‘profit maximization’ by providing quality products at appropriate prices, in comparison of the competitors. The firm also wants to satisfy its clientele. Through this objective, the store wants to acquire major expansion. It currently wishes to enlarge its services by attaining perfection in the in the operational activities. Kudler also desires to increaseRead MoreKudler Fine Foods Hris Analysis1344 Words   |  6 PagesAbstract Kudler Fine Foods is a specialty food store consisting of a workforce of approximately 17 employees at their administration office, 31 employees at their La Jolla store, 38 employees at their Del Mar store and 38 employees at their Encinitas store, totaling 124 employees (Kudler Fine Foods Intranet). Each location manages their own employees’ information on their own database. This proves to be a problem since all Human Resources and employee information should be managed at the administrativeRead MoreKudler Fine Foods Problem Statement801 Words   |  4 Pagesresearched is how Kudler Fine Foods can improve the success of the business by preparing for possible competition, and streamlining expansion procedures. The sources used are the Kudler Fine Foods Strategic Plan, and The University of Phoenix online databases. Findings suggest that implementing a research and market analysis plan, as well as an effective risk management plan will ensure successful expansion and growth of Kudler Fine Foods. A risk management plan and market analysis of new locationsRead MoreEssay on Kudler Fine Foods Data Table Analysis865 Words   |  4 PagesThe company Kudler Fine Foods supplies the freshest ingredients and the tools enabling their customers to become a gourmet cook. They are a specialized food store with a worldwide selection of vegetables, meats, wines, and cheeses. The stores are owned by Kathy Kudler, and today continue to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opened her first store in La Jolla, and after a five-year plan, opened her third store in EncinitasRead MoreDetailed Design Process1733 Words   |  7 PagesDesign Preliminary Design Model [Placeholder] Tradeoff Approach Though an ultimate and extravagant system is desired for Kudler Fine Foods’ Frequent Shopper Program, it is likely that some tradeoffs will have to be made to ensure that the project remains feasible for the company. In designing the Frequent Shopper Program for Kudler Fine Foods, it is important to consider certain tradeoffs of the project, in terms of costs, the schedule of the project, and the performance of the system, regardlessRead MoreInventory Control System Case Study: Kudler Fine Foods1326 Words   |  6 PagesKudler Fine FoodsUniversity of PhoenixSmith Systems Consulting (SSC) has been contracted by Kudler Fine Foods to develop a frequent shopper program. Kudler Fine Foods goal with the frequent shopper program is to develop customer loyalty and penetrate new market shoppers while tracking their behavior. Smith Systems Consulting has been able to design, host, develop, maintain, support and program systems development for their clients since 1984. Smith Systems Co nsulting employs over 350 employees andRead MoreMarketing Focus for Kudler Fine Foods1356 Words   |  6 Pagesfor Kudler Fine Foods Virtual Organization Roslyn Broadhurst BSA/502 July 26, 2010 David Moore Abstract Kudler Fine Foods currently has three locations-La Jolla, Del Mar, and Encinitas-throughout San Diego, with a fourth location possibly in the company’s near future. The company maintains several systems including strategic plan, legal, finance and accounting, sales and marketing, human resources, and operations. This paper is an analysis of the marketing system for Kudler Fine Foods, andRead MoreKulder Fine Foods - Frequent Shopper Program700 Words   |  3 PagesKulder Fine Foods - Frequent Shopper Program Kulder Fine Foods wants to create a frequent shopper program to help their customers by rewarding them, but also wanting them to be protected by malicious entities that might want to do them harm. In developing a Frequent Shopper Program, Kudler ne Foods (hereby known as Johnson) will need to implement, and adhere, to strict policies and guidelines that will protect the patrons that shop at the establishments of Kudler. We can also use different modelingRead MoreKudler Data Table Analysis786 Words   |  4 PagesData Table Analysis-Kudler Fine Foods ACC/542 July 30, 2012 Yasin Dadabhoy Data Table Analysis-Kudler Fine Foods Kudler Fine Foods is a rapidly growing retail company that began in 1998 that uses a Retail Enterprise Management System (REMS) to track customers, inventory, sales and employees. Being that the majority of Kudler’s inventory is perishable its inventory must be consistently tracked. The following brief will evaluate data tables from an accounting perspective, and provide recommendationsRead MoreEco 365 Uop Differentiating Between Market Structures Essay1031 Words   |  5 PagesDifferentiating Between Market Structures ECO365 Kudler Fine Foods is the brain child of Kathy Kudler. She envisioned a one stop gourmet food store and has grown to three locations to date. She continues to maintain direct control over large bulk purchase order items, stringent customer service policies, and hiring. This paper discusses how the organization competes in the marketplace and the strengths and weaknesses of the company according to the marketing surveys their customers completed