Week2 Sql Query

arrive at DATABASE Kudler_Fine_Foods_Virtual_Organization; GO USE Kudler_Fine_Foods_Virtual_Organization; CREATE hold over Job_Title ( Job_Titlevarchar(50) non vigour uncreated KEY, EEO_1_classificationvarchar(25)not 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 recruit INTO Job_Title determine (Accounting Clerk, Office/Clerical, Computes, classifies, records, and verifies numerical data for hire in maintaining account statement records., 0 ); INSERT INTO Job_Title set (Assistant Manager, Officials & Managers, Supervises and coordinates activities of workers in department of aliment throw in. 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 demonstrate to count and total customers purchases in grocery store., 0); INSERT INTO Job_Title VALUES (Computer Support Specialist, Technician, Installs, modifies, and makes pocketab le repairs to personal computer hardware a! nd bundle systems, 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