Kudler Fine Foods Database(Sql) Essay

983 words - 4 pages

Kudler Fine Foods Database

Week 3 Assignment

University at Phoenix

POS/410

Vic Echeverria

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 ...view middle of the document...

00','F','32','9')

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
('9','Nguyen','Meredith', '10583 Arenas St', 'La Jolla', 'CA', '619','5550102', '08-01-1998','Computer Support Specialist','43000.00','M','25','5')

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
('10','Stephens','Harvey', '7863 High Bluff Drive', 'La Jolla', 'CA', '619','5550123', '08-01-1998','','','M','','11')

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
('11','Vu','Matthew', '981 Torrey Pines Rd', 'La Jolla', 'CA', '619','5550138', '08-01-2000','Computer Support Specialist','37000.00','M','26','5')

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
('12','Ledonna','Avery', '198 Dovernor Dr', 'Del Mar', 'CA', '619','5550135', '03-01-2003','Craft Workers (Skilled)','21000.00','F','23','7')

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
('13','Drohos','Craig', '', 'Solano Beach', 'CA', '619','5550202', '04-30-2000','Officials & Managers','51000.00','M','32','2')

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
('14','Meier','Elaine', '9703 Orchid Lane', 'Del Mar', 'CA', '858','5550112', '08-10-2000','Sales Workers','20500.00','F','51','4')

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
('15','Quillan','Stanley', '98542 Wandering Road, Apt 2B', 'Del Mar', 'CA', '760','5550198', '01-01-1999','Operatives (Semi...

Other Essays Like Kudler Fine Foods Database(Sql)

Kudler Fine Foods Essay

985 words - 4 pages Kudler Fine Foods is a premiere gourmet grocery store that offers shoppers the finest baked goods, meats, cheese and dairy, produce items and an assortment of domestic and imported wines. Kudler Fine Foods offers all customers a wonderful shopping experience and the finest quality of foods and wines. Leaving room to expand its current services and opening new locations. The company’s growth span is leading to an increased customer base. Kudler

Kudler Fine Foods- Marketability Essay

1581 words - 7 pages Kudler Fine Foods functions as an affluent specialty grocery store in the Southern California region. The founder of Kudler Fine Foods, Kathy Kudler, turned a dream into a reality when she opened the first store in 1998 and hasn’t looked back since. In the corporations first year of operation, they could turn a profit and maintain their unique character. The company shares a common goal and mission with its employees, which encompasses customer

Kudler Fine Foods

945 words - 4 pages demonstrate strong management. A manager that can incorporate Porter’s Five-Force Model is one that recognizes the threats to the company’s profitability and ultimate position in the industry. This paper will explore the management functions of Kudler Fine foods using the Porter’s Five-Forces Model. This paper will also exam the use of technology and the internet and how it affects management. Kudler Fine Foods is a gourmet foods shop founded by

Kudler Fine Foods

1149 words - 5 pages Kudler Fine Foods Kudler Fine Foods is a specialty food store with three locations currently. The owner and founder is Kathy Kudler and established in 1998. Kathy strides to give her customers the best specialty food with exceptional service. Kathy visits each of her stores regularly and does a lot of the back office work so her management team and sales associates can interact with the customers on a regular basis and keep up an exceptional

Kudler Fine Foods - 1343 words

1343 words - 6 pages Kudler Fine Foods PAGE 2 IKudler Fine FoodsUniversity of PhoenixKudler Fine Foods is an upscale store that sells gourmet items for gourmet cooks. Kudler has three separate locations and a solid customer base. However, if Kulder is to expand to more locations and increase the customer base, new marketing strategies need to be developed. Research and development, competitive intelligence and the importance of marketing research will all be

Kudler Fine Foods - 1679 words

1679 words - 7 pages Kudler Fine Foods Sonia Shelby MMPBL 502 January 15, 2012 Dr. Patricia Anderson Abstract In the wake of growth, expansion, and overcoming temporary closing some departments for renovations, Kudler Fine Foods (Kudler) made the right business decisions to renovate its store sequentially; thereby eliminating the need to downsize its workforce. Management temporarily relocated affected employees to one of the other stores not under

Kudler Fine Foods - 753 words

753 words - 4 pages Running head: Kudler Fine Foods Frequent Shopper Program Kudler Fine Foods Frequent Shopper Program University of Phoenix Abstract Kudler Fine Foods is developing a new Frequent Shopper Program. This program will track customer purchases through the Frequent Shopper Program to award loyalty points for redemption. This paper will discuss the potential legal, ethical, and information security

Kudler Fine Foods - 1499 words

1499 words - 6 pages Virtual Organization Strategy for Kudler Fine Foods For many organizations, strategic decisions play an important role in how the organization plans to expand its business and its profits. There are many factors management must consider before making a final decision as to which approach will provide the most benefits as well as bringing in the most capital. Each approach considered will present strengths, weaknesses, opportunities, and risks

Kudler Fine Foods Simulation

971 words - 4 pages Kudler Fine Foods Kudler Fine Foods is a fashionable specialty food store located in sunny San Diego, California. There are three sites as of now La Jolla, Del Mar and Encinitas California. Each location is supplied with the finest of domestic and imported items. Each location is stocked with fresh bakery products, fruits and vegetables, deli, meats and seafood and a dairy department. Kudler’s unlocked the doors to the first store in 1998

Kudler Fine Foods Resources

950 words - 4 pages Kudler Fine Foods Human Resources Analysis Mary Lewis BSA 502 August 6, 2012 Vanessa Johnson Kudler Fine Foods Human Resources Analysis After reviewing Kudler Fine Foods Human Resource HRIS web page there are a number of areas that can be benefitted by implementing an automated system to assist in centralizing employee records and related HR information, time tracking and timesheet submittal, and tracking applicants. IT is being

Kudler Fine Foods Unfinished

537 words - 3 pages “Introduction Kudler Fine Foods (KFF) has plans to begin offering organic produce to their customers. This will be a bold move and first major change in product offerings since KFF began operations in 1998. Kudler will need to move slowly and consider all angles in how this will affect the current operations. KFF will need to consider how this will impact their business processes and supply chain. Due to the perishable nature of Organic

Related Papers

Kudler Fine Foods Essay 766 Words

766 words - 4 pages important that the customers of Kudler Fine Foods are reassured that all data will be kept in-house and that any information that is given will remain within Kudler's database. Frequent shopper programs are becoming a trend in this day and age within the retail sector. Kudler Fine Foods will be using electronic commerce to implement the frequent shopper program. Implementation of electronic commerce will enable Kudler's to do their shopping via on

Kudler Fine Foods Strategy Essay

1694 words - 7 pages Kudler Fine Foods – Strategy “Strategic competitiveness can be attained only when the firm’s selected structure is congruent with its formulated strategy” (Gomez-Mejia. 2002). Kudler has positioned itself to make use of its existing information technology structure, marketing scheme and sales objectives to create a well-known atypical grocer business in their slot market by leveraging the increased changes in the marketplace and shifting

Kudler Fine Foods Essay 1459 Words

1459 words - 6 pages 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 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

Kudler Fine Foods Essay 1811 Words

1811 words - 8 pages Kudler Fine Foods ECO 365 August 19, 2013 Christopher Rakovalis Kudler Fine Foods Kudler Fine Foods evaluation and examination of the market trends in the industry in which operates presentation takes special interest in this paper. How market trends play a role in the market structure, effect of new companies entering the market, prices, and technology, productivity, cost structure, price elasticity of demand, competitors, supply