Week2 Sql Query

arrive at DATABASE Kudler_Fine_Foods_Virtual_Organization; GO USE Kudler_Fine_Foods_Virtual_Organization; CREATE gameboard Job_Title ( Job_Titlevarchar(50) non vigour primary winding 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 figure INTO Job_Title set (Accounting Clerk, Office/Clerical, Computes, classifies, records, and verifies numerical data for hire in maintaining visor records., 0); INSER T INTO Job_Title value (Assistant Manager, Officials & Managers, Supervises and coordinates activities of workers in department of aliment line. Assists store manager in daily operations of store.

, 1); INSERT INTO Job_Title value (Bagger, Sales Workers, Places customer orders in bags. Performs carryout duties for customers., 0); INSERT INTO Job_Title VALUES (Cashier, Sales Workers, Operates cash recital 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 product 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