Queries

ies

CREATE TABLE JOB_TITLE

(

EEO_1_classification VARCHAR (20) NOT NULL,

Job_Title_id VARCHAR (5) PRIMARY KEY,

Job_Title VARCHAR (50) NOT NULL,

Job_Description VARCHAR (100) NOT NULL,

exempt VARCHAR (4) NOT NULL

)

GO

CREATE TABLE employee

(

id_num INT IDENTITY (1, 1) PRIMARY KEY,

Last VARCHAR (15) NOT NULL,

First VARCHAR(15) NOT NULL,

address VARCHAR (50) NOT NULL,

City VARCHAR (20) NOT NULL,

State VARCHAR (2) NOT NULL,

Telephone_area_code INT NOT NULL,

Telephone_number VARCHAR (10) NOT NULL,

EEO_1_classification VARCHAR (20) NOT NULL,

Hire_Date DATETIME NOT NULL,

Salary DECIMAL (10,2),

Gender CHAR(1) NOT NULL,

Age INT NOT NULL,

Job_title_id VARCHAR (5) CONSTRAINT FK_Employee_Job_title FOREIGN KEY REFERENCES Job_title (Job_title_id)

)

GO

INSERT INTO JOB_TITLE VALUES

('Office Clerical', '30', 'Accounting Clerk', 'maintains computes records','No');

INSERT INTO JOB_TITLE VALUES

('Officials Managers', '31', 'Asst Manager', 'supervises coordinates workers', 'Yes');

INSERT INTO JOB_TITLE VALUES

('Sales Worker', '32', 'Bagger', 'places customer items in bags', 'No');

INSERT INTO JOB_TITLE VALUES

('Sales Workers', '33', 'Cashier', 'itemize and total customer’s purchases', 'No');

INSERT INTO JOB_TITLE VALUES

('Technician','34','Computer Support Specialist', 'Updates software maintain hardware provides training technical assistance', 'Yes');

INSERT INTO JOB_TITLE VALUES

('Officials Managers', '35','Director of Finance Accounting', 'plans and directs the finance and accounting activities','Yes');

INSERT INTO JOB_TITLE VALUES

('Craft Workers', '36', 'Retail Asst. Bakery & Pastry','monitors workers','No');

INSERT INTO JOB_TITLE VALUES

('Operatives', '37', 'Retail Asst. Butchers and Seafood Specialist', 'monitors workers', 'No');

INSERT INTO JOB_TITLE VALUES

('Stocker', '38', 'Office clerical','Stores, prices and restocks merchandise displays in store', 'No');...