USE KUDLER
CREATE TABLE JOB_TITLE
(
eeo_1_classification VARCHAR (20) NOT NULL,
job_title_id VARCHAR (5)  PRIMARY KEY,
job_title VARCHAR (50) NOT NULL,	
j_description  VARCHAR (100) NOT NULL,
exempt VARCHAR (4) NOT NULL		
 )

CREATE TABLE employee
(
id_num INT IDENTITY (1, 1) PRIMARY KEY,
last_name VARCHAR (15) NOT NULL,
first_name 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,
date_of_birth VARCHAR (100) NOT NULL,
ssn VARCHAR (10) NOT NULL,
job_title_id VARCHAR (5) 
CONSTRAINT FK_Employee_Job_title 
FOREIGN KEY REFERENCES Job_title (Job_title_id)
)

INSERT INTO  JOB_TITLE VALUES
('Office Clerical', '071', 
'Accounting Clerk', 
'Maintains and computes all records',
'No');

INSERT INTO JOB_TITLE  VALUES
('Officials Managers', '062', 
'Asst Manager', 
'Supervises and coordinates workers', 
'Yes');

INSERT INTO JOB_TITLE VALUES
('Sales Worker', '053', 
'Bagger', 
'Places customer items in bags',  
'No');

INSERT INTO JOB_TITLE VALUES
('Sales Workers', '084', 'Cashier', 'itemize and total customer’s purchases', 'No');

INSERT INTO JOB_TITLE VALUES
('Technician','095','Computer Support Specialist', 'Updates software maintain hardware provides training  technical assistance', 'Yes');

INSERT INTO JOB_TITLE VALUES
('Officials  Managers', '016','Director of Finance  Accounting', 'plans and directs the finance and accounting activities','Yes');

INSERT INTO JOB_TITLE VALUES
('Craft Workers', '027', 'Retail Asst. Bakery & Pastry','monitors workers','No'); 

INSERT INTO JOB_TITLE VALUES
('Operatives', '038', 'Retail Asst. Butchers and Seafood Specialist', 'monitors workers', 'No');  

INSERT INTO JOB_TITLE  VALUES
('Stocker', '049', 'Office clerical','Stores, prices and restocks merchandise displays in store', 'No');

INSERT INTO EMPLOYEE  VALUES
('Edelman','Glenn','175 Bishops Lane','La_Jolla','CA','619','555-0199','123456789',
'07-OCT-2003',21500.75,'M','01-JAN-1946','084');

INSERT INTO Employee VALUES
(
'Edelman','Glenn','175 Bishops Lane','La_Jolla','CA','619','555-0199','123456789',
'07-OCT-2003',21500.75,'M','01-JAN-1946','084');

INSERT INTO Employee VALUES
(
'McMullen','Eric','763 Church St','Lemon Grove','CA','619','555-0135','234567890',
'1-NOV-2002',13500.00,'M','03-FEB-2010','084');

INSERT INTO Employee  VALUES
('Slentz','Raj','123 Torrey Dr.','North Clairmont','CA','619','555-0123','157863498',
'1-JUN-2000',48000.00,'M','25-MAR-2010','016');  

INSERT INTO Employee VALUES
('Broun','Erin','2045 Parkway Apt.2B','Encinitas','CA','760','555-0100','654983473',
'12-MAR-2003',10530.00,'F','19-APR-2010','053');

INSERT INTO Employee VALUES
('Carpenter','Donald','927 Second ST.', 'Encinitas','CA','619','555-0154','468656425',
'1-NOV-2003', 15000.00,'M','05-MAY-1992','071');

INSERT INTO Employee VALUES
('Esquivez','David','10983 N. Coast Hwy Apt 902','Encinitas','CA','760','555-0108','560348976',
'25-JUL-2003',18500.00,'M','12-JUN-1985','038'); 

INSERT INTO Employee VALUES
('Sharp','Nancy','10793 Monteciono Rd','Ramona','CA','858','555-0135','556332157',
'12-JUL-2003',21000.00,'F','29-JULY-1986','053');   

Select * from employee
Select * from job_title

INSERT INTO Employee VALUES
(
'McMullen',
'Eric',
'763 Church St',
'Lemon Grove',
'CA',
'619',
'555-0135',
'234567890',
'1-NOV-2002',
13500.00,
'M',
'03-FEB-2010', --DOB
'084') -- SSN or Job Title? One is missing..