Week2 Sql Query

arrive at DATABASE Kudler_Fine_Foods_Virtual_Organization; GO USE Kudler_Fine_Foods_Virtual_Organization; CREATE put over Job_Title ( Job_Titlevarchar(50) non vigour special KEY, EEO_1_classificationvarchar(25) non bootless, Job_Descriptionvarchar(200) NOT NULL, Exempt_non_exempt_statusbit NOT 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, Salary bullion NOT NULL, Genderchar(1)NOT NULL, Ageint NOT NULL, Job_Titlevarchar(50) NOT NULL FOREIGN KEY REFERENCES Job_Title(Job_Title) ); Go move into INTO Job_Title value (Accounting Clerk, Office/Clerical, Computes, classifies, records, and verifies numerical data for hire in maintaining bloom records., 0); INSERT INT O Job_Title set (Assistant Manager, Officials & Managers, Supervises and coordinates activities of workers in department of aliment lineage. Assists store manager in daily operations of store.

, 1); INSERT INTO Job_Title determine (Bagger, Sales Workers, Places customer orders in bags. Performs carryout duties for customers., 0); INSERT INTO Job_Title VALUES (Cashier, Sales Workers, Operates cash point to count and total customers purchases in grocery store., 0); INSERT INTO Job_Title VALUES (Computer Support Specialist, Technician, Installs, modifies, and makes pocketable repairs to persona l computer hardware and software system sys! tems, and provides technical assist and training 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 want to get a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay