Premium Essay

Kudler Fine Food Database

In:

Submitted By gschool78
Words 875
Pages 4
Kudler Fine Foods Database

Week 3 Assignment

University at Phoenix

POS/410

Outline:

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by creating queries to select all columns from each table. Use the database and tables from last week’s assignment to write SQL queries using Between and Like. Write an SQL query for each of the following: • Join the two tables in the example database and use BETWEEN to restrict record selection. Use salary to restrict data.

• Join the two tables in the example database and use BETWEEN to restrict record selection. Use hire date to restrict data. • Join the two tables in the example database and use LIKE to restrict record selection. Use telephone area code to restrict data. • Joins the two tables in the example database and use LIKE to restrict record selection. Use age to restrict data. Use the updated database to write the following queries, using the GROUP BY clause: • Select employees’ last names and group them by EEO-1 classification. • Select employees’ last names and group them by salary. • Select employees’ last names and group them by salary in their EEO-1 classification. • Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

--Insert Statement for Administrative Offices and Del Mar staff

Insert into Employee (Employee_ID, Last_Name,First_Name,Address,City,State,Area_Code,Telephone_nm,Hire_Dt,EEO1,Salary,Gender,Age,JobTitle_Key)
VALUES
('8','McNamara','Juanita', '923 Parkway', 'Roway', 'CA', '614','5550290',

Similar Documents

Premium Essay

Kudler

...Kudler Fine Foods Introduction Kudler Fine Foods has reviewed a significant growth in business. Expansion has been discussed on implementing services, increasing consumer purchase cycle and furthering efficiency of Kudler Fine Foods operations. Kudler Fine Foods strategic objective is to increase loyalty and profitability from customers. Customer’s purchases will be tracked through a Frequent Shopper Program using a point-of-sale (POS). The program will keep track of an individual customer’s purchase or purchases and provide high end incentives through a partnership with a loyalty points program (Kudler Fine Foods, 2009). Kudler’s partnership with a loyalty points program will provide customers with a points program where the customer can redeem points for high-end gift items, specialty foods and first-class airline upgrades (Kudler Fine Foods, 2009). Team A has been invited to create a business/systems requirement document to initiate the development of the Frequent Shopper Program. Team A will outline in the following document Team A’s proposed plan in meeting the objective of the aforementioned request. Executive Summary ------------------------------------------------- Kathy Kudler’s vision became a reality in 1998 when she opened her first store in La Jolla, California. Gourmet cooking coupled with efficient food preparation was the cornerstone of the La Jolla store (Apollo, 2008). Kudler’s has expanded with the opening of the Del Mar location and with Kudler’s latest...

Words: 1257 - Pages: 6

Free Essay

Frequent Shopper Program System

...Frequent Shopper Program System Kathy Kudler, President of Kudler Fine Foods wants to put in place a program to let existing customers know they are valuable to the store and persuade them to shop with greater frequency. The customer-buying model will help Kudler improve its practices and assistance to please their appreciated customers. Cost is not a main concern for Kudler customers; these customers are interested in high quality and specialized goods. Therefore, Kudler has requested a Frequent Shopper Program System with a “loyalty points program to provide customers with points that they redeem for high-end gift items, airline first-class upgrades, or other specialty foods” (ecampus.phoenix.edu, 2011). The Frequent Shopper Program System for Kudler Fine Foods will track purchase behavior of individual customers and provide high value incentives by installing a customer loyalty points program. “Point of Sale Software” (camcommerce.com, n.d.) “Retail STAR Point of Sale (POS) software provides a solution for customer tracking, managing inventory, and selling inventory via sales orders or point-of-sale transactions” (camcommerce.com, n.d.). The software program has a CRM (Customer Relationship Management) module built into Retail STAR. Retail STAR Point of Sale Software can computerize all of Kudler’s sales data and provide executive management with a balance sheet and profit and loss statement at the end of each sale day. Retail STAR will track all the vital information...

Words: 908 - Pages: 4

Premium Essay

Bsa 310 Critical Information System Paper

...Information System Paper Ted Ko, BSA 310 University of Phoenix August 21, 2011 Greg Walker Critical Information System Kudler Fine Foods is a local gourmet grocery store located in San Diego, with three locations. All the stores carry the very best domestic and imported goods. Kathy Kudler, Owner of Kudler Fine Foods, opened the first of three stores in 1998. In the year 2000, Kathy opened a second store with the third store opening in 2003 (Kudler Virtual Organization, 2006). Kudler Fine Foods utilizes an information technology system that is vital to its business. The company uses the POS (Point of Sales) Database System to organize and keep track of items and orders. Without this, they would not be as successful as they are. Point of Sales System Databases keeps track of inventory, supplier, order, customer, store, tender (sales), tax table, order line, and item. A successful business cannot function accurately without all these tables. The Inventory Table contains the components that make up an item. Such as, perishable indicator, quantity on hand, and unit cost. It is also “used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, ect” (Kudler Virtual Organization, 2006). “The Supplier Table data concerning wholesalers, vendors and other suppliers from whom inventory is procured” (Kudler Virtual Organization, 2006). Meaning, depending on the inventory, which is going to determine who the supplier is going...

Words: 546 - Pages: 3

Premium Essay

Individual Marketing Paper

...Marketing Research Paper MKT-421 Individual Marketing Research Paper Kudler Fine Foods While developing the Kudler Fine Foods marketing campaign strategy it is critical to identify areas which will need additional marketing research. By identifying areas for needed additional market research, Kudler Fine Foods can better target its marketing strategy and tactics. By analyzing competitive intelligence, Kudler Fine Foods can better assess opportunities within its current marketing strategy. Background Kudler Fine Foods was founded in 1998 when its first store was built by Kathy Kudler. The company maintains its main base in San Diego, California and services the neighborhoods of La Jolla, Del Mar, and Encinitas. Each store has more than 16,000ft of modernized groceries and fresh organic specialty foods. Kudler Fine Foods prides itself on offering high quality foods, both domestic and imported. The company maintains specific strategic practices to introduce planning unrealistic goals and objectives. Although the company services a niche market in a minimal geographic area, the grocery industry is inherently competitive. The success of the company is attributed to its high standards in human resources and inventory control. By identifying additional areas for marketing research and analyzing competitive intelligence, Kudler Fine Foods will be able to expand its operations and establish more locations. The...

Words: 1318 - Pages: 6

Premium Essay

Kudler Fine Foods

...Kudler Fine Foods BSA310 April 15, 2012 Kudler Fine Foods Kudler Fine Foods is an upscale specialty food store based in the San Diego area. There are three locations and each carries a variety of domestic and imported products, such as pastries, produce, meat, seafood, cheese, dairy, and packaged foods. Kudler’s keeps a database that is critical to the business processes of the company. In addition to the details kept about customer orders and demographics, information is catalogued for inventory, purchase orders, suppliers, and taxes. This enables a manager to quickly and accurately see what is happening and make appropriate decisions. These decisions include making timely orders from suppliers and keeping proper staffing levels at each location to ensure excellent customer service. The Customer Table contains data about customers to streamline the ordering process and helps with addresses and dates for special mailings. This simple tool allows Kudler’s to provide a personal touch along with better service. The Inventory Table determines available ingredients that make up an Item. For example, it is important for a baker to know how much flour he has in stock so that he/she can order more from a supplier before it runs out so that the company is always producing a product for the customer to buy. The Item Table lists all the finished goods that can be purchased from a particular store. Managers can make decisions about which products...

Words: 1205 - Pages: 5

Premium Essay

Marketing Focus

...Abstract The Kudler Fine Foods is a high-end gourmet food store in San Diego with three different locations; La Jolla, Del Mar and Encinitas. Each store has around 16,000 square feet of retail space, and each store is within a popular metropolitan shopping center (Apollo Group, 2004). The stores are known for possessing the finest high-quality foods; each store is divided into the following departments: Fresh Bakery and Pastries, Fresh Produce, Fresh Meat and Seafood, Cheeses and Special Dairy Products, and Condiments and Packaged Foods (Apollo Group, 2004). Kudler’s upscale specialty food store chain is doing something similar to other grocers, but adding an ingenious twist. As part of the company’s strategic objective to increase loyalty and profitability of consumers, Kudler Fine Foods is planning three objectives; expanding services, implementing a frequent shopper program, and increasing efficiency by reducing costs. Marketing Focus Kudler Fine Foods is a high-end gourmet food store located in San Diego. Kudler Fine Foods has three different locations, La Jolla, Del Mar and Encinitas. Each store has around 16,000 square feet of retail space, and each store is within a popular metropolitan shopping center (Apollo Group, 2004). The stores are known for possessing the finest the high-quality foods; each store is divided into the following departments: Fresh Bakery and Pastries, Fresh Produce, Fresh Meat and Seafood, Cheeses and Special Dairy...

Words: 1616 - Pages: 7

Premium Essay

Business

...Kudler Fine Foods Frequent Shopper Program Team A BSA/375 February 28, 2012 Name Frequent Shopper Program Statement of Scope and Goals The goal for this Service Request is to design a fully integrated rewards program, thus the Frequent Shopper Program. This program will help track customer purchases and reward the consumers in loyalty points. These loyalty points can be redeemed at any time toward the rewards program products and services. Kudler will benefit by being able to track the items most commonly purchased by consumers. Furthermore, Kudler can develop reports that illustrate what is most popular based on the season, time of day, and with current trends in the market. With this newly acquired material, Kudler to have certain specials for the products to reward their loyal consumers. To ensure Kudler’s Frequent Shopper Program is successful, Kudler will need to keep its competitive edge by remaining current in the market and current trends. In addition to conduction market research, Kudler will need to consistently strive to provide exceptional service at all times, along with the best values in town. Consumers are always looking for the store that has the best deals with the best service. By providing deals on items personally geared at a particular consumer based on their previous purchases will make the shopping experience more personal and catered toward the customers individual needs. Advertising is also a large contributor in how successful...

Words: 1228 - Pages: 5

Premium Essay

Kudler Fine Foods Frequent Shopper Program

...Kudler Fine Foods Frequent Shopper Program Kudler Fine Foods is an upscale store which specializes in the highest quality specialty food items both imported and domestic. There are three stores in the San Diego area, they are in La Jolla, Del Mar and Encinitas. The departments within each store are: • Fresh Bakery and Pastries • Fresh Produce • Fresh Meat and seafood • Condiments and packaged Foods • Cheeses and Specialty Dairy Products The founder and owner Kathy Kudler put in a service request to develop a system that tracks customer purchases. This system will award loyalty points in a frequent shopper program. Before they implement the program Kudler Fine Foods will need to research several business considerations to ensure they keep their customer’s information safe and secure. These considerations include legal, security and ethical implications. In this paper I will detail the legal, security and ethical considerations of e-commerce. The paper will also detail a point-of-sale system that will be used to track Kudler’s customer’s purchases and award points. In conclusion a description of the financial analysis that will show why the expenditure or this program is justified for use at Kudler Fine Foods. Frequent Shopper Program Kudler Fine Foods would like to develop a frequent shopper program. A program such as this will track a customer’s purchases at the point of sale and reward them with points. The customer can use accumulated points to be redeemed later for...

Words: 1502 - Pages: 7

Premium Essay

Kudler Fine Foods Service Request Sr-Kf-013

...Kudler Fine Foods Service Request SR-kf-013 BSA375 Business Systems Development Abstract Kudler Fine Foods, an upscale specialty gourmet foods shop with three locations (La Jolla, Del Mar and Encinitas), has an expressed interest in the development of a Frequent Shopper Program to enable enhanced information management by tracking customer-purchasing practices. The information collected regarding customer purchase behaviors through the Frequent Shopper Program will improve the quality of Kudler Fine Foods’ product lines and reduce the quantities of perishables discarded. To increase revenue and customer loyalty, and as an alternative to providing discounts, Kudler Fine Foods has partnered with a loyalty points program to offer incentives for customer loyalty in the form of high-end rewards for shopping at Kudler Fine Foods. Customers will earn points with every purchase, redeemable for high-value gift items such as first-class airline upgrades, and other specialty items (Apollo Group, Inc., 2007). Facilitating this effort will require systems planning and selection as well as current and proposed systems analysis and design, in conjunction with systems implementation and integration, training, operations, and maintenance. Kudler Fine Foods Service Request SR-kf-013 Initiatives Outline Kathy Kudler, the founder of Kudler Fine Foods, opened her first gourmet food shop in 2003. Since that time, two additional stores have opened, and other locations in Carlsbad...

Words: 7143 - Pages: 29

Premium Essay

Kudler Fine Foods Service Request Sr-Kf-013

...Kudler Fine Foods Service Request SR-kf-013 BSA375 Business Systems Development Abstract Kudler Fine Foods, an upscale specialty gourmet foods shop with three locations (La Jolla, Del Mar and Encinitas), has an expressed interest in the development of a Frequent Shopper Program to enable enhanced information management by tracking customer-purchasing practices. The information collected regarding customer purchase behaviors through the Frequent Shopper Program will improve the quality of Kudler Fine Foods’ product lines and reduce the quantities of perishables discarded. To increase revenue and customer loyalty, and as an alternative to providing discounts, Kudler Fine Foods has partnered with a loyalty points program to offer incentives for customer loyalty in the form of high-end rewards for shopping at Kudler Fine Foods. Customers will earn points with every purchase, redeemable for high-value gift items such as first-class airline upgrades, and other specialty items (Apollo Group, Inc., 2007). Facilitating this effort will require systems planning and selection as well as current and proposed systems analysis and design, in conjunction with systems implementation and integration, training, operations, and maintenance. Kudler Fine Foods Service Request SR-kf-013 Initiatives Outline Kathy Kudler, the founder of Kudler Fine Foods, opened her first gourmet food shop in 2003. Since that time, two additional stores have opened, and other locations in Carlsbad...

Words: 7121 - Pages: 29

Premium Essay

Kindler Fine Foods

...Kudler Fine Foods Misty Robinson MMPBL/502-Managing the Business Enterprise Abstract Kudler Fine Foods is an upscale food store in the San Diego metropolitan area, specializing in fine foods and wines. This paper will explore the primary functions of management and who is responsible for each function. Also, how Kudler Fine Foods is utilizing the use of technology and the internet within the organization. Table of Contents Introduction…………………………………………………………………………………….. 4 Primary Functions of Management at Kudler Fine Foods……………………………………... 4 The Use of Technology and the Internet……………………………………………………….. 5 Five Forces – Porter’s Model……………………………………………………………………6 Conclusion……………………………………………………………………………………….7 References……………………………………………………………………………………….8 Kudler Fine Foods Introduction Kathy Kudler, founder of Kudler Fine Foods, has a passion for gourmet cooking, which requires the use of gourmet ingredients. She was often tasked in finding the ingredients she needed to prepare the gourmet meals she desired. While out shopping one day she realized there was a great demand for a fine food store, one that could offer the finest ingredients and other specialty items at a reasonable price. Kathy had a vision; it was then that the first Kudler Fine Foods was opened in 1998. The store is driven by its mission statement – “our selections, coupled with our experienced, helpful and knowledgeable staff, merge to offer each customer a delightful and pleasing shopping...

Words: 1337 - Pages: 6

Free Essay

Data Table Analysis

...Data Table Analysis University of Phoenix Accounting Information Systems ACC/542 Anita Rodriguez April 2, 2012 Data Table Analysis Kudler Fine Foods was founded by Kathy Kudler in La Jolla in 1998. In the beginning, Kudler Fine Foods had only one store, causing Kathy Kudler to make the decision to use the Microsoft Access database to monitor and maintain sales, employees, inventory, customers, and orders. Because Kudler Fine Foods inventory was perishable, it was imperative to track properly these items. Possessing too much inventory was always a concern of Kudler Fine Foods, if the inventory information was inaccurate, outdated, or incomplete the information would be of no use to the company. This paper will present suggestions for enhancement, evaluate database tables from an accounting point of view, and generate a pivot table to assist the management of Kudler Fine Foods with preparing improved reports in accounting and enhance the decision-making process. Evaluate the design elements of the data tables from an accounting perspective The inventory tables allow the users to establish when to order additional inventory and what inventory is on hand. The use of data table analysis is of the essence for this process. The data table is intended to categorize the data into departments, financial codes, items, and it adds the total amount for the transaction codes. It also adds the amount of items in the inventory during a specified period. The data table design...

Words: 903 - Pages: 4

Premium Essay

Security Report

...Kudler Fine Foods IT Security Report Kudler Fine Foods IT Security Report Kudler Fine Foods is a specialty food store that has three stores located in San Diego, Ca. Kudler Fine Food strives to ensure their customers are happy and stay shopping at their stores. Kudler Fine Foods is starting a frequent shopper program. The new program will require a new system that Kudler will need to design and secure. First potential security threats need to be identified. Throughout the system development, process security will need to be considered. Kudler will need to address concerns if the new system is ever removed. Information security policies will need to be developed to ensure the security of Kudler and their customers. The employees of Kudler will need to go through security awareness training. In addition, audit provisioning by the Kudler staff will need to be addressed. This paper will discuss each of the security issues that Kudler will have to cover. Most Critical Threats Identified With the implementation of the improved customer rewards program many systems will need to be secured and possible threats and vulnerabilities need to be identified. Kudler’s current servers need to be properly secured to ensure they are not hacked or attacked by malicious code. If Kudler’s servers are hacked customers information like addresses, phone numbers, and email addresses could be used by attackers to try to acquire log on information. This is known as phishing, were an attacker...

Words: 3971 - Pages: 16

Premium Essay

Kudler Fine Foods

...Kudler Fine Foods BSA310- Business Systems University of Phoenix Abstract 
 Contemporary businesses depend heavily on information systems. These are systems in which data and information flow from one person or department to another. These systems encompass everything from interoffice mail and telephone links to computer and communication systems that generate reports. They serve all the systems of a business by linking the different components together so that they work effectively toward the same goal. Information systems can reside at various levels and within all functional areas within an organization. These systems are very critical to the business process of an organization. They also have an impact on an organization's structure. 


 Introduction Kudler Fine Foods is an upscale food store in San Diego with three locations (La Jolla, Del Mar and Encinitas). The store was founded by Kath Kudler who was the vice president of a large defense contractor. Kathy started cooking gourmet food and found an opportunity to open an upscale gourmet shop in 1998. Within three years she had three stores open. By interviewing Kathy Kudler helped me to analyze the needs for her company. Learning the existing process allowed me to understand the current process flow. This gave me the opportunity to compare it to the new process to determine the advantages and disadvantages of the new database management system, computer network, and electronic business...

Words: 857 - Pages: 4

Premium Essay

View All Resources Alphabetically

...Kudler Fine Foods’ Loyalty Card Program Kudler Fine Foods has submitted a service request to develop a frequent shopper program to track customer trends and give frequent customers rewards for being loyal customers. Many grocery stores have adopted a rewards or loyalty program. This program gives the customers a discount while they shop and sometimes offers rewards and prizes. By using this program, a store also collects valuable data that can be used to specify which customers by certain items. This information can then be used to tailor advertisements and coupons to each customer. This program will hopefully increase sales by providing a more efficient marketing plan to customers. Many other grocery stores have found that using a loyalty program can increase profits and customer base. In a recession, such as the one we are currently experiencing, it is important to maintain the customer base that a company has worked so hard to obtain. According to Colloguy research (as cited in Helbig, 2009), “U.S. consumer participation in rewards programs is on the rise across all demographic segments, . . . Consumers are leaning on loyalty programs to stretch household budgets further by earning rewards for their purchases” (para. 7). Many grocery stores use a loyalty program for tracking customer purchases and offering discounts. This loyalty program comes in the form or a card. When a customer decides they want to part of the loyalty program, they fill out a form....

Words: 2561 - Pages: 11