Week2 Sql Query

arrive at DATABASE Kudler_Fine_Foods_Virtual_Organization; GO delectation Kudler_Fine_Foods_Virtual_Organization; CREATE TABLE Job_Title ( Job_Titlevarchar(50) non vim prime KEY, EEO_1_classificationvarchar(25) non bootless, Job_Descriptionvarchar(200) not NULL, Exempt_non_exempt_statusbit non NULL ); GO CREATE TABLE Employee ( Employee_IDint NOT NULL IDENTITY PRIMARY KEY, Last_namevarchar(25)NOT NULL, First_namevarchar(25)NOT NULL, Addressvarchar(50)NOT NULL, Cityvarchar(25)NOT NULL, call downchar(2)NOT NULL, Telephone_area_codevarchar(3)NOT NULL, Telephone_numbervarchar(8)NOT NULL, Hire_datedatetime NOT NULL, wages bullion NOT NULL, Genderchar(1)NOT NULL, Ageint NOT NULL, Job_Titlevarchar(50) NOT NULL external KEY REFERENCES Job_Title(Job_Title) ); Go enrol INTO Job_Title VALUES (Accounting Clerk, Office/Clerical, Computes, classifies, records, and verifies numerical data for hire in maintaining bill records., 0); enrol INTO Job_Title VALUES (Assistant Manager, Officials & Managers, Supervises and coordinates activities of workers in department of aliment instal. Assists store manager in fooling operations of store.

, 1); INSERT INTO Job_Title VALUES (Bagger, Sales Workers, Places node orders in bags. Performs carryout duties for customers., 0); INSERT INTO Job_Title VALUES (Cashier, Sales Workers, Operates silver register to count and issue forth customers purchases in grocery store., 0); INSERT INTO Job_Title VALUES (Computer Support Specialist, Technician, Installs, modifies, and makes pocketable repairs to individual(prenominal) computer hardware and bundle systems, and provides technical assist and educate to system users., 0); INSERT INTO Job_Title VALUES (Director of finance & Accounting, Officials & Managers, Plans and directs the finance and accounting activities for Kudler...If you loss to get a sufficient essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper