Week 2 Individual Assignment - Table Queries & Screen Shots

Week 2 Individual Assignment – Table Queries & Screen Shots SQL for Business POS/410 October 8, 2012 Prof - Week 2 Individual Assignment - Table Queries & Screen Shots introduction. Keith Martin * Create a working database that will be used during the next 3 * weeks to build and test SQL statements * * Author: * Date: 08 October, 2012 ****************************************************************/ /* * 2. 1 Create an SQL Server database for Kudler Fine Foods * and create the following two tables */ — Create the database using CREATE DATABASE CREATE DATABASE KulderFineFood; GO — Use KulderFineFood as the current database USE KulderFineFood; – Create the Job_title table. CREATE TABLE Job_title ( Job_title varchar(50) NOT NULL PRIMARY KEY, EEO_1_Classification varchar(30) NOT NULL, Job_description varchar(250) NOT NULL, Exempt_Non_Exempt_Status bit NOT NULL ); GO — Create the Employee using CREATE TABLE CREATE TABLE Employee ( Emp_id int NOT NULL IDENTITY(1,1) PRIMARY KEY, Last_name varchar(25) NOT NULL, First_name varchar(25) NOT NULL, Address varchar(40) NOT NULL, City varchar(15) NOT NULL,

State char(2) NOT NULL, Telephone_area_code varchar(3) NOT NULL, Telephone_number varchar(8) NOT NULL, Job_title varchar(50) NOT NULL FOREIGN KEY REFERENCES Job_title(Job_title), Hire_date smalldatetime NOT NULL, Wage money NOT NULL, Gender char(1) NOT NULL, Race varchar(25) NOT NULL, Age int NOT NULL ); GO /* * 2. 2 Using the SQL INSERT statement, * enter records into the tables */ — Insert Job_title records INSERT INTO Job_title VALUES ‘Accounting Clerk’, ‘Office/Clerical’, ‘Computes, classifies, records, and verifies numerical data for use in maintaining accounting records. ‘, 0); INSERT INTO Job_title VALUES (‘Assistant Manager’, ‘Officials & Managers’, ‘Supervises and coordinates activities of workers in department of food store. Assists store manager in daily operations of store. ‘, 1); INSERT INTO Job_title VALUES (‘Bagger’, ‘Sales Workers’, ‘Places customer orders in bags. Performs carryout duties for customers. ‘, 0); INSERT INTO Job_title VALUES (‘Cashier’, ‘Sales Workers’, ‘Operates cash register to itemize and total customer”s purchases in grocery store. , 0); INSERT INTO Job_title VALUES (‘Computer Support Specialist’, ‘Technician’, ‘Installs, modifies, and makes minor repairs to personal computer hardware and software systems, and provides technical assistance and training to system users. ‘, 1); INSERT INTO Job_title VALUES (‘Director of Finance & Accounting’, ‘Officials & Managers’, ‘Plans and directs the finance and accounting activities for Kudler Fine Foods. ‘, 1);

Need essay sample on "Week 2 Individual Assignment – Table Queries & Screen Shots"? We will write a cheap essay sample on "Week 2 Individual Assignment – Table Queries & Screen Shots" specifically for you for only $12.90/page

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.

More Essay Examples on SQL Rubric

INSERT INTO Job_title VALUES (‘Retail Asst. Bakery & Pastry’, ‘Craft Workers’, ‘Obtains or prepares food items requested by customers in retail food store. ‘, 0); INSERT INTO Job_title VALUES ‘Retail Asst. Butchers & Seafood Specialists’, ‘Operatives’, ‘Obtains or prepares food items requested by customers in retail food store. ‘, 0); INSERT INTO Job_title VALUES (‘Stocker’, ‘Office/Clerical’, ‘Stores, prices and restocks merchandise displays in store. ‘, 0); GO — Insert the Employee records INSERT INTO Employee VALUES (‘Edelman’, ‘Glenn’, ‘175 Bishops Lane’, ‘La Jolla’, ‘CA’, ‘619’, ‘555-0199’, ‘Cashier’, ’07-OCT-2003′, 21500. 00, ‘M’, ‘Caucasian’, 64); INSERT INTO Employee VALUES (‘McMullen’, ‘Eric’, ‘763 Church St’, ‘Lemon Grove’, ‘CA’, ‘619’, ‘555-0133’, ‘Bagger’, ‘1-NOV-2002’, 13500. 0, ‘M’, ‘Caucasian’, 20); INSERT INTO Employee VALUES (‘Slentz’, ‘Raj’, ‘123 Torrey Dr. ‘, ‘North Clairmont’, ‘CA’, ‘619’, ‘555-0123’, ‘Assistant Manager’, ‘1-JUN-2000’, 48000. 00, ‘M’, ‘Asian’, 34); INSERT INTO Employee VALUES (‘Broun’, ‘Erin’, ‘2045 Parkway Apt. 2B’, ‘Encinitas’, ‘CA’, ‘760’, ‘555-0100’, ‘Bagger’, ’12-MAR-2003′, 10530. 00, ‘F’, ‘Caucasian’, 24); INSERT INTO Employee VALUES (‘Carpenter’, ‘Donald’, ‘927 Second ST. ‘, ‘Encinitas’, ‘CA’, ‘619’, ‘555-0154’, ‘Stocker’, ‘1-NOV-2003’, 15000. 00, ‘M’, ‘African American’, 18); INSERT INTO Employee VALUES (‘Esquivez’, ‘David’, ‘10983 N.

Coast Hwy Apt 902′, ‘Encinitas’, ‘CA’, ‘760’, ‘555-0108’, ‘Retail Asst. Butchers & Seafood Specialists’, ’25-JUL-2003′, 18500. 00, ‘M’, ‘Hispanic’, 25); INSERT INTO Employee VALUES (‘Sharp’, ‘Nancy’, ‘10793 Monteciono Rd’, ‘Ramona’, ‘CA’, ‘858’, ‘555-0135’, ‘Cashier’, ’12-JUL-2003′, 21000. 00, ‘F’, ‘Caucasian’, 24); GO /* * 2. 3 Check the results by selecting all of the columns * from both of your tables. */ SELECT * FROM Employee; SELECT * FROM Job_title; GO —————————————————————————————————————– Scree Shots of Toolwire Lab – Individual Assignment

Haven’t Found A Paper?

Let us create the best one for you! What is your topic?

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.

Haven't found the Essay You Want?

Get your custom essay sample

For Only $13/page