This website uses cookies to ensure you have the best experience. Learn more

Kudler Fine Foods Database Analysis

1725 words - 7 pages

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 initially seem like a large files size, it can rapidly grow and eventually reach this maximum size in a relatively short amount of time. This one drawback alone is reason enough to pursue a better solution.

Another aspect of Microsoft Access that does not scale well is that it will not accommodate multiple users simultaneously. The database needs to be updated continuously by multiple users at each store. Running one instance of Microsoft SQL Server 2000 in a centralized location could easily handle the database needs of all of the store locations. Connections to the database could be made via Virtual Private Network (VPN) connections over the Internet. Updates to the database can be further streamlined by developing and utilizing a web based interface.

The best solution for Kudler Fine Foods would be to implement an enterprise level database solution. Microsoft SQL Server 2000 would be a great fit for the database needs of Kudler Fine Foods. Microsoft SQL Server 2000 will easily meet the current needs of Kudler Fine Foods and also meet their needs of the future as they continue their growth.

Existing Database Overview

Currently the Kudler database contains nine tables. Each table is designed
to support and facilitate the filling of orders placed by customers in the stores. Based upon the description of the tables that was posted on Kudler’s intranet and our analysis, the tables may be described in the following manner:

The Customer table contains demographic data for each of Kudler’s customers. The data in this table is used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birth dates, etc. Each record in the customer table contains a customer_id field that is used to link the customer to the orders that they place.

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....

Find Another Essay On Kudler Fine Foods Database Analysis

Kudler Fine Foods-Marketing Essay

1106 words - 4 pages that need to be improved, will assist the business to increase the loyalty of their customers and profitability of consumers.ReferencesApollo Group, Inc. (2007). Kudler Fine Foods. Sales & Marketing. Retrieved January 13, 2010. MKT/421 - Marketing. https://ecampus.phoenix.edu/secure/aapd/cist/VOP/Business/Kudler/Sales/KudlerSM001.htmPerreault, W. D., Cannon, J. P., & McCarthy, E. J. (2009). Basic Marketing: A Marketing Strategy Planning Approach, (17th ed.). Retrieved January 14, 2010from University of Phoenix eBook Collection Database.

Kudler Fine Foods Essay

887 words - 4 pages AbstractIn this paper the author will be discussing the importance of marketing, the development of Kudler Fine Foods by the strategic tactics the company use, where the author believes more research is needed so that Kudler Fine Foods can be successful, and the author will provide an analysis of the strategy tactics that Kudler Fine Foods use.Kudler Fine Food'sKudler Fine Foods, founded by Kathy Kudler is a specialty food store that has a home

Kudler Fine foods

652 words - 3 pages lies with Security issues, all customers information will be confidential to ensure the integrity of Kudler's clients. Focusing on the security policy will also encourage and support the loyalty Kudler's customers. An assessment of the current's system will be done performing a risk analysis searching for all risks and levels of extremities of the risk.Management at Kudler Fine Foods must make sure all legal aspects of the company are met. Loyalty

Kudler Fine Foods

1277 words - 5 pages additional market research is needed and the importance of competitive intelligence and analysis as it relates to the marketing strategy and tactics.The first Kudler Fine Foods store was opened on June 18, 1998, in La Jolla, California, by Kathy Kudler. Two years later a second location opened in Del Mar, and in 2003, a third location opened in Encinitas. Each store is an upscale specialty food store located in a fashionable shopping center. The

Mrs. Kudler Fine Foods

1525 words - 7 pages For a business to thrive well, they should invest in proper marketing. Since there is very high competition in the market, a business ought to make sure that they are well known within and beyond their market region. Many firms do survive in the market. However, “The firms that gain loyal customers by providing unique value is the essence of successful marketing” (Kerin et al., Chapter 1, pg 14). Kudler fine Foods have a well strategized

Kudler Fine Foods Marketing

1751 words - 7 pages Kudler Fine Foods-Marketing PAGE \* MERGEFORMAT 6 Kudler Fine Foods-MarketingBrian R. DuncanUniversity of PhoenixMBA-502July 15, 2008"The firms that gain loyal customers by providing unique value is the essence of successful marketing" (Kerin et al., Chapter 1, pg 14). Through a variety of sales and marketing strategies, Kudler Fine Foods plans to increase customer loyalty and profitability. The customer focused programs, frequent shopper

Kudler Fine Foods

708 words - 3 pages Kudler Fine Foods is an upscale specialty food store, with three locations in California. The three stores are located in La Jolla, Del Mar and Encinitas. Each location has approximately 16,000 square feet of space and getting the most out of this space is what Kudler wants to do. Kudler Fine Foods has experienced a significant growth and is now focused on expanding its services through its new marketing strategies.Kudler's marketing strategies

Kudler Fine Foods Network

788 words - 4 pages After reviewing the Kudler Fine Food network, a major network overhaul will need to bring the network up to par with the latest technology. If Kudler Fine Foods is not able to upgrade their systems then they will fall behind the technological curve and will not be able to compete with other companies. Kudler needs to do the upgrade not only to keep up with the advances with network systems but needs to install the proper systems to increase

Kudler Fine Foods - 1131 words

1131 words - 5 pages University of PhoenixKudler Fine Foods, a privately held company, is an upscale specialty food store. The organization includes three locations in the San Diego metropolitan area, La Jolla, Del Mar, and Encinitas. The three retail buildings have approximately 16,000 square foot each, all of which are located in high quality shopping centers. Kudler Fine Foods now wanting to expand its business operations faces a difficult decision to go public

Kudler Fine Foods Marketing Research

1061 words - 4 pages the finest epicurean delights (Kudler Fine Foods, 2011). To be successful Kathy Kudler had to do her homework and rely on marketing research to develop her marketing strategy. With the use of competitive intelligence and analysis she has quickly started a successful business that has been able to break even and show a profit in only nine months from the startup of the company.Importance of marketing researchMarketing research is an important part

Strategy Assignment - Kudler Fine Foods

1551 words - 6 pages necessary software, train associates to access these orders, and employ a database system to track these orders for future use.StrategyKudler Fine Foods appears to be pursuing a differentiation strategy, in which it offers products and services that its customers perceive as "unique." By following this strategy, Kudler Foods will be required to continuously offer new products and features so customers will believe these products differ from the

Similar Essays

Kudler Fine Foods Database Project Essay

888 words - 4 pages Kudler Fine Foods Database Project Background and Business Application Proposal Kudler Fine Foods is an upscale specialty food store, servicing the fine food conesouer from their three California locations. Kudler's business objective is to maximize profits by offering the highest quality products at competitive prices. Through adding the on-line ordering system, Kudler hopes to boost profits by increasing their customer base beyond

Kudler Fine Foods Essay 517 Words

517 words - 2 pages Kudler Fine Foods is a rapidly growing business located in the San Diego Metropolitan area of California. Founded in 1998, Kudler specializes in providing superiority gourmet foods to a wide range of customers and business.When Kudler opened its first store 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

Kudler Fine Foods Essay 1275 Words

1275 words - 5 pages consists of contact information for vendors and wholesalers which supply the inventory to Kudler Fine Foods. The tax table is a tool used to determine the correct tax to charge a specific account based on the location of the store, state of sale, and etc. The tender table records the methods of payments used to purchase an order and can be utilized to accept partially cash or credit. (Kudler Fine Foods Database, University of Phoenix Virtual

Kudler Fine Foods Essay 1635 Words

1635 words - 7 pages focuses will provide the benchmarks and goals of the final program.The first focus be benefits to Kudler Fine Foods from this frequent shopper program. The obvious benefit would be to retain existing shoppers while attracting new ones. If this was the sole focus then Kudler would miss the additional benefits that can be developed for marketing, growth and customer analysis. Demonstrating customer analysis Lenius (1996) quotes Peg Merzbacher, a