Essay PreviewMore ↓
The company is a store name Kudler Fine Foods, supplying 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 cheese, to mention a few. The stores are own by Kath Kudler, became a reality in 1998, and today continues to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opens her first store in La Jolla, and after a five-year plan, opens her third store in Encinitas. She is committed to providing her customers with the very best selection of fine foods and great wines.
The project is that of a Microsoft 2000 Access database representing all the associated Kudler Fine Foods stores. The current database utilizes tables that are in reference to customers and the organization operations. Many of the tables require normalization, creating new tables, Entity Relational Model (ERM) relationships, and investigating the requirements of associated indexes. New reports are required in support of the relationships between tables, business operations, and the necessities in meeting the need of the customer.
The current tables are as follows:
Customer 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.
Inventory 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.
Item The Item Table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store.
Order 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.
Order Line The Order Line table contains detail 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.
Store The Store Table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc.
Supplier The Supplier Table contains data concerning wholesalers, vendors and other suppliers from whom inventory is procured. These goods are used to prepare saleable items or are simply resold in their acquired form.
How to Cite this Page
"Kudler Fine Foods." 123HelpMe.com. 25 Feb 2020
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- Kudler Fine Foods Overview of Management Kudler Fine Foods is an upscale specialty food store located in San Diego, California. What started out as a small endeavor has escalated into three stores throughout the San Diego metropolitan area. The three stores are located within existing shopping centers and contain the following departments: bakery and pastries, produce, meat and seafood, condiments and packaged foods and finally cheese's and specialty dairy products (Kudler Fine Foods - Home).... [tags: Kudler Fine Foods Case Study]
1757 words (5 pages)
- Kudler Fine Foods is a store unlike any in the grocery industry. Kudler Fine Foods represents a store that could possibly spark a new era within the grocery world. The owner of Kudler Fine Foods, Kathy Kudler, has watched her dream of owning and operating a grocery store that specializes in fine quality food grow within a short period of time. The success of Kudler Fine Foods can be attributed to the innovative ideas, effective leadership, and organizational structure. The overall mission of Kudler Fine Food's "is to provide our customers the finest in selected foodstuffs, wines, and related needs in an unparallel consumer environment.... [tags: Kudler Fine Foods Case Study]
1693 words (4.8 pages)
- Strategic Planning Kudler Fine Foods is committed to providing its customers with the finest selection of the very best foods and wines. Kudler has enjoyed successful growth by standing behind this commitment, but would now like to expand its services, and improve the efficiency of its operation (University of Phoenix, 2006). This requires flexible market strategies that are developed based on analysis of current internal and external forces affecting the company. Proper analysis and implementation will provide a successful strategy resulting in a sustainable competitive advantage (Gomez-Mejia & Balkin, 2002).... [tags: Kudler Fine Foods Case Study]
1552 words (4.4 pages)
- As part of its strategic growth plan to attract new customers, Kudler Fine Foods, a gourmet food shop based in southern California, has decided to contract with local organic farmers to provide fresh organic produce to its three existing stores. Owner, Kathy Kudler's incentive for this plan lays in consumer trends which is expects the organic foods industry to grow from $41.2 Billion to $62 Billion in just three years (Progressive Grocer, 2006). Success of this initiative will depend on the careful analysis of affected operations management processes, supply chain activities, and quality control systems.... [tags: Kudler Fine Foods Case Study]
1904 words (5.4 pages)
- Strategy Assignment Kathy Kudler is the creator of Kudler Fine Foods. Kathy’s primary goal in establishing KFF was to create a retail store that provides a selection of gourmet foods in order to meet the needs of the typical person all within one store. A wide variety of foods are offered at Kudler Fine Foods. The many different departments include gourmet baked goods, dairy, cheese, wine, organic and non organic produce sections, fresh meats, and seafood. Furthermore, the three different retail locations will offer cooking classes in addition to monthly cheese and wine customer appreciation classes.... [tags: Kudler Fine Foods Case Study Analysis]
1290 words (3.7 pages)
- Strategy Assessment Kudler Fine Foods Kudler Fine Foods was established by Kathy Kudler in June 1998 with the opening of one store in La Jolla. Her plan was to offer a one stop shopping experience for those people who were in search of quality ingredients for gourmet cooking. Due to the success of the La Jolla store, two additional stores were opened in Del Mar and Encinitas. The mission of Kudler Fine Foods has been modified “to provide their customers with the finest in selected foodstuffs, wines, and related needs in an unparalleled consumer environment” (Virtual Organizations, 2008).... [tags: Case Study Strategy Assessment Kudler Fine Foods]
921 words (2.6 pages)
- Kudler Fine Foods is an organization that wants to evolve and mature as a company and implement practices that illustrate their growth as a company. One particular practice that Kudler Foods wants to implement is reaching out and contracting to local farmers to gain access to organic foods for sell within all three branches of Kudler Foods (UOP,2008). By implementing such a new system changes will have to be made primarily within the company’s operations management. This paper will discuss the needed changes and alterations that need to occur in order to maintain their efficiency as a company.... [tags: Kudler Fine Foods Case Study Analysis]
1461 words (4.2 pages)
- The Need of an Upgraded System for Kudler Fine Foods Kudler fine Foods are in dire need of an upgraded system as well as a better constructed database. It is recognized that there are three stores involved, and downtime is unacceptable. This document will outline the requirements needed from different section, such as Marketing, Human Resources, and Management to name a few. Currently, there is a collection of information, but many of the systems are not automated. We will outline areas that we feel need improvement.... [tags: Kudler Fine Foods Marketing Finances Essays]
1364 words (3.9 pages)
- Kudler Fine Foods Transforms to Organic Produce The Kudler Fine Foods is transforming its produce to carry organically grown produce. In the company's mission statement: "We will provide this service because we shop the world' for our products; purchase only the finest of products and will go to extensive lengths to assure that Kudler's is the purveyor of choice for customers aspiring to purchase the finest epicurean delights (Kudler Fine Foods, 2006). Kathy Kudler and her administrative team have decided to contract with local vendors to bring organic produce to the stores.... [tags: Kudler Foods Case Study Analysis]
1997 words (5.7 pages)
- Kudler Fine Foods is a full service specialty grocery store. It operates from three locations within upscale neighborhoods in San Diego, Ca. As a self proclaimed gourmet cook, Kathy saw that there was need for a centralized location to shop for the ingredients needed to create her dishes. After years in corporate America, Kathy made a decision to turn her passion into a new career. As a result, Kudler Fine Foods was founded in 1998. Management Structure Kudler employs 127 workers. Kathy acts as the company president.... [tags: Case Study Kudler Grocery]
1228 words (3.5 pages)
Tax Table The purpose of the Tax Table is to provide tax rates applicable to orders placed at a given store.
Tender The Tender Table provides a means to record the methods of payment used for an Order. For an example, an order may be paid for partially in cash and partially by credit card.
The current Kudler Fine Foods Entity Relationship Model (ERM) diagram:
The current Kudler data model permitted our team to capture and understand the present flow of information. The ERM diagram, developed as part of the data modeling process, was used as a communication media with each other to analysis the business operations. The focus of the ERM model is to capture the relationships between various entities of the organization or process for which we design the model. The ERM diagram is a tool that our team used to assist in analyzing the business requirements and in the design of the resulting data structure.
The current Kudler Fine Foods Entity Relationship Model (ERM) diagram:
Generally, a model is that of an abstraction and reflection of the real world in reference to Kudler Fine Foods operations. In creating tables, modeling gives us the capacity to visualize what we, up until now, could not realize. It is the same with data modeling. The primary plan of our data model is to make sure that all the data objects accurately represent the database during the normalization. The data model will easily verify and decipher primary keys, foreign keys, and tables used in the new design collectively with the current tables in building the data structure and the verification of the appointed index.
Our objective of normalization is to reduce redundancy by not containing the same data stored in numerous tables. As a result, normalization can minimize any integrity issues because SQL permits us to update a single table when required. However, queries, particularly those involving larger tables, which include a join of the data stored in multiple normalized tables, this may require additional effort to achieve an acceptable performance to the business operations.
Although data in normalized tables minimizes redundancy, it became a challenge for us to navigate. Our team believes if an analyst must navigate a data model that requires a join of 15 tables; it may likely be difficult and not very intuitive. As a team, we strongly recommend third normal form for OLTP applications since data integrity requirements are stringent, and joins involving large numbers of rows are minimal.
Our ERM focuses on three major contributions, entities, attributes, and relationships. An entity is any category of an object in which the Kudler Fine Foods is interested. Each entity has a corresponding business definition to define the boundaries of the entity allowing our team to decide whether a particular object belongs to that assigned category or entity.
Identify the requirements:
We focused on both the ERM and dimensional model of the business giving us an improved capability to visualize the abstract questions concerning the business functionality.
The Dimensional Model
The required tables in the normalization phase:
Granularity of the dimension
Related Source Tables
The order represents what is sold on a given date and includes the customer information and store location.
Order Line The order line will supply the ORDER_table in information about the product sold to the customer.
The tax table will be included to illustrate the location of the store in meeting the requirements of that county. This table requires a tax code, the tax percent, and the jurisdiction of described tax information.
The payment method illustrates the type of payment make for the purchase of product. This table requires Cash', Check', Money Order', and Credit Card'.
Customer table will include full name, complete address, phone, and fax number.
This table will included birthday, anniversary date, and email address for mailings of specials and special events.
The store information table requires only that of a store code, manager code, store hour code, and complete address of store location to include phone and fax numbers.
The store information table requires the store code, is the store owned or leased, floor space, cost of rent or ownership, contact person, and phone number.
The store manager makes many of the operational decisions and requires a table to present personal information to include employee number, full name, address, two phone numbers and his/her email address.
The store hour's table allows each store to change hours in view of holidays or to except change as needed.
The product table requires a product code, band name, description, unit cost, and the unit of measure to reflect the association to price.
The inventory requires knowledge of type of product, category, the department association, the amount on hand, assembly type, substitute type, described tag type, and if the item is perishable and to accommodated with date.
The supplier will illustrate the company in supplying the product. The table will include the company name, full address, phone/fax number, in town or out of town indicator, and the type of account.
This table will permit a one-to-many relationship in describing a list of products and descriptions with a supplier for a quick query to order needed supplies.
Utilizing dimensional modeling, our team can easily understand and navigate the data structure and fully exploit the data requirements. Actually, data is simply a record of Kudler Fine Foods business activities, resources, and results of the organization. The data model is a well-organized abstraction of the required data. The data model naturally became the best method for us to understand and manage the operations. We believe, as a team, that without a data model, it would be difficult to organize the structure and contents of the data in the data warehouse.