create table employee (emp_id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30),

email VARCHAR(30), phone_no VARCHAR(30), hire_date DATE, job_id VARCHAR(20), salary

DECIMAL(10, 2), comm_pct DECIMAL(10, 2), mgr_id INT, dept_id INT, PRIMARY
KEY(emp_id), FOREIGN KEY(mgr_id) REFERENCES employee(emp_id));

create table department (dept_id INT NOT NULL, dept_name VARCHAR(30), mgr_id INT,
location_id INT, PRIMARY KEY (dept_id), FOREIGN KEY(mgr_id) REFERENCES
employee(emp_id));

ALTER TABLE employee ADD FOREIGN KEY (dept_id) REFERENCES department (dept_id);

create table locations (location_id INT NOT NULL, street_address VARCHAR(50),

postal_code VARCHAR(30), city VARCHAR(50), state_province VARCHAR(30), country_id
VARCHAR(2) NOT NULL, PRIMARY KEY (location_id));

ALTER TABLE department ADD FOREIGN KEY (location_id) REFERENCES locations

(location_id);

create table jobs (job_id VARCHAR(15) NOT NULL, job_title VARCHAR(50), min_salary
DECIMAL(10,2), max_salary DECIMAL(10,2), PRIMARY KEY (job_id));

ALTER TABLE employee ADD FOREIGN KEY (job_id) REFERENCES jobs(job_id);

create table job_history (emp_id INT NOT NULL, start_date DATE, end_date DATE,
job_id VARCHAR(20), dept_id INT, PRIMARY KEY (emp_id), FOREIGN KEY (emp_id)
REFERENCES employee (emp_id), FOREIGN KEY (job_id) REFERENCES jobs (job_id),
FOREIGN KEY (dept_id) REFERENCES department (dept_id));

create table job_grade (grade_level CHAR, lowest_sal DECIMAL(10, 2), highest_sal

DECIMAL(10, 2), PRIMARY KEY (grade_level));

create table countries (country_id VARCHAR(2) NOT NULL, country_name VARCHAR(30),

region_id INT, PRIMARY KEY(country_id));

ALTER TABLE locations ADD FOREIGN KEY (country_id) REFERENCES countries

(country_id);

X------------------X------------------X------------------X------------------
X------------------X------------------X------------------X------------------
X----------------

create table Countries (country_id VARCHAR(2) PRIMARY KEY,country_name

VARCHAR(30),region_id INT);

create table Location (location_id INT PRIMARY KEY,street_address

VARCHAR(50),postal_code VARCHAR(20),city VARCHAR(50),state_province
VARCHAR(50),country_id VARCHAR(2) REFERENCES Countries(country_id));

create table Department (dept_id INT PRIMARY KEY,dept_name VARCHAR(50),manager_id

INT,location_id INT REFERENCES Location(location_id));

create table Job_grade (grade_level INT PRIMARY KEY,lowest_sal DECIMAL(10,

2),highest_sal DECIMAL(10, 2));

create table Jobs (job_id VARCHAR(10) PRIMARY KEY,job_title VARCHAR(30),min_salary

DECIMAL(10, 2),max_salary DECIMAL(10, 2));

create table Employees (emp_id INT PRIMARY KEY,fname VARCHAR(20), lname

VARCHAR(20),email VARCHAR(100),phone_no VARCHAR(15),hire_date DATE,job_id
VARCHAR(10) REFERENCES Jobs(job_id),salary DECIMAL(10, 2),commission_pct
DECIMAL(10, 2),manager_id INT REFERENCES Employees(emp_id),dept_id INT REFERENCES
Department(dept_id));

create table Job_history (emp_id INT,start_date DATE,end_date DATE,job_id

VARCHAR(15) REFERENCES Jobs(job_id),dept_id INT REFERENCES
Department(dept_id),PRIMARY KEY (emp_id),FOREIGN KEY (emp_id) REFERENCES
Employees(emp_id));

X------------------X------------------X------------------X------------------
X------------------X------------------X------------------X------------------
X-----------------X---------------

insert into employee values

(100, 'Steven', 'King', 'SKING', '515.123.4567', '2003/06/17', 'AD_PRES', 24000, 0,
NULL, 90),
(101, 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568', '2005/09/21', 'AD_VP', 17000,
0, 100, 90),
(102, 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569', '2001/01/13', 'AD_VIP', 17000,
0, 100, 90),
(103, 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567', '2006/01/03', 'IT_PROG',
9000, 0, 102, 60),
(104, 'Bruce', 'Ernst', 'BERNST', '590.423.4568', '2007/05/21', 'IT_PROG', 6000, 0,
103, 60),
(105, 'David', 'Austin', 'DAUSTIN', '590.423.4569', '2005/06/25', 'IT_PROG', 4800,
0, 103, 60),
(106, 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560', '2006/02/05', 'IT_PROG',
4800, 0, 103, 60),
(107, 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567', '2007/02/07', 'IT_PROG',
4200, 0, 103, 60),
(108, 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569', '2002/08/17', 'FI_MGR',
12008, 0, 101, 100),
(109, 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169', '2002/08/16', 'FI_ACCOUNT',
9000, 0, 108, 100),
(110, 'John', 'Chen', 'JCHEN', '515.124.4269', '2005/09/28', 'FI_ACCOUNT', 8200, 0,
108, 100),
(111, 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369', '2005/09/30', 'FI_ACCOUNT',
7700, 0, 108, 100),
(112, 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469', '2006/03/07',
'FI_ACCOUNT', 7800, 0, 108, 100),
(113, 'Luis', 'Popp', 'LPOPP', '515.124.4567', '2007/12/07', 'FI_ACCOUNT', 6900, 0,
108, 100),
(114, 'Den', 'Raphely', 'DRAPHEAL', '515.127.4561', '2002/12/07', 'PU_MAN', 11000,
0, 100, 30),
(115, 'Alexander', 'Khoo', 'AKHOO', '515.127.4562', '2003/05/18', 'PU_CLERK', 3100,
0, 114, 30),
(116, 'Shell', 'Baida', 'SBAIDA', '515.127.4563', '2005/12/24', 'PU_CLERK', 2900,
0, 114, 30),
(117, 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564', '2005/07/24', 'PU_CLERK', 2800,
0, 114, 30),
(118, 'Guy', 'Himuro', 'GHIMURO', '515.127.4565', '2006/11/15', 'PU_CLERK', 2600,
0, 114, 30),
(119, 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566', '2007/08/10', 'PU_CLERK',
2500, 0, 114, 30),
(120, 'Matthew', 'Weiss', 'MWEISS', '650.123.1234', '2004/07/18', 'ST_MAN', 8000,
0, 100, 50),
(121, 'Adam', 'Fripp', 'AFRIPP', '650.123.2234', '2005/04/10', 'ST_MAN', 8200, 0,
100, 50),
(122, 'Payam', 'Kaufling', 'PKAUFLIN', '650.123.3234', '2003/05/01', 'ST_MAN',
7900, 0, 100, 50),
(123, 'Shanta', 'Vollman', 'SVOLLMAN', '650.123.4234', '1005/10/10', 'ST_MAN',
6500, 0, 100, 50),
(124, 'Kevin', 'Mourgos', 'KMOURGOS', '650.123.5234', '2007/11/16', 'ST_MAN', 5800,
0, 100, 50),
(125, 'Julia', 'Nayer', 'JNAYER', '650.124.1214', '2005/07/16', 'ST_CLERK', 3200,
0, 120, 50),
(126, 'Irene', 'Mikkilieneni', 'IMIKKILI', '650.124.1224', '2006/09/28',
'ST_CLERK', 2700, 0, 120, 50);

insert into employee values

(127, 'James', 'Landry', 'JLANDRY', '650.124.1334', '2007/01/14', 'ST_CLERK', 2400,
0, 120, 50),
(128, 'Steven', 'Markle', 'JMARKLE', '650.124.1434', '2008/03/08', 'ST_CLERK',
2200, 0, 120, 50),
(129, 'Laura', 'Bissot', 'LBISSOT', '650.124.5234', '2005/08/20', 'ST_CLERK', 3300,
0, 121, 50),
(130, 'Mozhe', 'Atkinson', 'MATKINSO', '650.124.6234', '2006/10/30', 'ST_CLERK',
2800, 0, 121, 50),
(131, 'James', 'Marlow', 'JMARLOW', '650.124.7234', '2005/02/16', 'ST_CLERK', 2500,
0, 121, 50),
(132, 'TJ', 'Olson', 'TJOLSON', '650.124.8234', '2007/04/10', 'ST_CLERK', 2100, 0,
121, 50),
(133, 'Jason', 'Mallin', 'JMALLIN', '650.127.1934', '2004/06/14', 'ST_CLERK', 3300,
0, 122, 50),
(134, 'Michael', 'Rogers', 'MROGERS', '650.127.1834', '2006/08/26', 'ST_CLERK',
2900, 0, 122, 50),
(135, 'Ki', 'Gee', 'KGEE', '650.127.1734', '2007/12/12', 'ST_CLERK', 2400, 0, 122,
50),
(136, 'Hazel', 'Philtanker', 'HPHILTAN', '650.127.1634', '2008/02/06', 'ST_CLERK',
2200, 0, 122, 50),
(137, 'Renske', 'Ladwig', 'RLADWIG', '650.121.1234', '2003/07/14', 'ST_CLERK',
3600, 0, 123, 50),
(138, 'Stephen', 'Stiles', 'SSTILES', '650.121.2034', '2005/10/26', 'ST_CLERK',
3200, 0, 123, 50),
(139, 'John', 'Seo', 'JSEO', '650.121.2019', '2006/02/12', 'ST_CLERK', 2700, 0,
123, 50),
(140, 'Joshua', 'Patel', 'JPATEL', '650.121.1834', '2006/04/06', 'ST_CLERK', 2500,
0, 123, 50),
(141, 'Trenna', 'Rajz', 'TRAJZ', '650.121.8009', '2003/10/17', 'ST_CLERK', 3500, 0,
124, 50),
(142, 'Curtis', 'Davies', 'CDAVIES', '650.121.2994', '2005/01/29', 'ST_CLERK',
3100, 0, 124, 50),
(143, 'Randall', 'Matos', 'RMATOS', '650.121.2874', '2006/03/15', 'ST_CLERK', 2600,
0, 124, 50),
(144, 'Peter', 'Vargas', 'PVARGAS', '650.121.2004', '2006/07/09', 'ST_CLERK', 2500,
0, 124, 50),
(145, 'John', 'Russel', 'JRUSSEL', '011.44.1344.429268', '2004/10/01', 'SA_MAN',
14000, 0.40, 100, 80),
(146, 'Karen', 'Partners', 'KPARTNER', '011.44.1344.467268', '2005/01/05',
'SA_MAN', 13500, 0.30, 100, 80),
(147, 'Alberto', 'Errazuriz', 'AERRAZUR', '011.44.1344.429278', '2005/03/10',
'SA_MAN', 12000, 0.30, 100, 80),
(148, 'Gerald', 'Cambrault', 'GCAMBRAU', '011.44.1344.619268', '2007/10/15',
'SA_MAN', 11000, 0.30, 100, 80),
(149, 'Eleni', 'Zlotkey', 'EZLOTKEY', '011.44.1344.429018', '2008/01/29', 'SA_MAN',
10500, 0.20, 100, 80),
(150, 'Peter', 'Tucker', 'PTUCKER', '011.44.1344.129268', '2005/01/30', 'SA_REP',
10000, 0.30, 145, 80),
(151, 'David', 'Bernstein', 'DBERNSTE', '011.44.1344.345268', '2005/03/24',
'SA_REP', 9500, 0.25, 145, 80),
(152, 'Peter', 'Hall', 'PHALL', '011.44.1344.478968', '2005/08/20', 'SA_REP', 9000,
0.25, 145, 80),
(153, 'Christopher', 'Olsen', 'COLSEN', '011.44.1344.498718', '2006/03/30',
'SA_REP', 8000, 0.20, 145, 80),
(154, 'Nanette', 'Cambrault', 'NCAMBRAU', '011.44.1344.987668', '2006/12/09',
'SA_REP', 7500, 0.20, 145, 80),
(155, 'Oliver', 'Tavault', 'OTAVAULT', '011.44.1344.486508', '2007/11/13',
'SA_REP', 7000, 0.15, 145, 80),
(156, 'Janette', 'King', 'JKING', '011.44.1345.429268', '2004/01/30', 'SA_REP',
10000, 0.35, 146, 80),
(157, 'Patrick', 'Sully', 'PSULLY', '011.44.1345.929268', '2004/03/04', 'SA_REP',
9500, 0.35, 146, 80);

insert into employee values

(158, 'Allan', 'McEwen', 'AMCEWEN', '011.44.1345.829268', '2004/08/01', 'SA_REP',
9000, 0.35, 146, 80),
(159, 'Lindsey', 'Smith', 'SMITH', '011.44.1345.729268', '2005/03/10', 'SA_REP',
8000, 0.30, 146, 80),
(160, 'Louise', 'Doran', 'LDORAN', '011.44.1345.629268', '2005/12/15', 'SA_REP',
7500, 0.30, 146, 80),
(161, 'Sarath', 'Sewall', 'SSEWALL', '011.44.1345.529268', '2006/11/03', 'SA_REP',
7000, 0.25, 146, 80),
(162, 'Clara', 'Vishney', 'CVISHNEY', '011.44.1346.129268', '2005/11/11', 'SA_REP',
10500, 0.25, 147, 80),
(163, 'Danielle', 'Greene', 'DGREENE', '011.44.1346.229268', '2007/03/19',
'SA_REP', 9500, 0.15, 147, 80),
(164, 'Mattea', 'Marvins', 'MMARVINS', '011.44.1345.329268', '2008/01/24',
'SA_REP', 7200, 0.10, 147, 80),
(165, 'David', 'Lee', 'DLEE', '011.44.1346.529268', '2008/02/23', 'SA_REP', 6800,
0.10, 147, 80),
(166, 'Sundar', 'Ande', 'SANDE', '011.44.1346.629268', '2008/03/24', 'SA_REP',
6400, 0.10, 147, 80),
(167, 'Amit', 'Banda', 'ABANDA', '011.44.1346.729268', '2008/04/21', 'SA_REP',
6200, 0.10, 147, 80),
(168, 'Lisa', 'Ozer', 'LOZER', '011.44.1343.929268', '2005/03/11', 'SA_REP',
11500, 0.25, 148, 80),
(169, 'Harrison', 'Bloom', 'HBLOOM', '011.44.1343.829268', '2006/03/23', 'SA_REP',
10000, 0.20, 148, 80),
(170, 'Tayler', 'Fox', 'TFOX', '011.44.1343.729268', '2006/01/24', 'SA_REP', 9600,
0.20, 148, 80),
(171, 'William', 'Smith', 'WSMITH', '011.44.1343.629268', '2007/02/23', 'SA_REP',
7400, 0.15, 148, 80),
(172, 'Elizabeth', 'Bates', 'EBATES', '011.44.1343.529268', '2007/03/24', 'SA_REP',
7300, 0.15, 148, 80),
(173, 'Sundita', 'Kumar', 'SKUMAR', '011.44.1343.329268', '2008/04/21', 'SA_REP',
6100, 0.10, 148, 80),
(174, 'Ellen', 'Abel', 'EABEL', '011.44.1644.429267', '2004/05/11', 'SA_REP',
11000, 0.30, 149, 80),
(175, 'Alyssa', 'Hutton', 'AHUTTON', '011.44.1644.429266', '2005/03/19', 'SA_REP',
8800, 0.25, 149, 80),
(176, 'Jonathon', 'Taylor', 'JTAYLOR', '011.44.1644.429265', '2006/03/24',
'SA_REP', 8600, 0.20, 149, 80),
(177, 'Jack', 'Livingston', 'JLIVINGS', '011.44.1644.429264', '2006/04/23',
'SA_REP', 8400, 0.20, 149, 80),
(178, 'Kimberly', 'Grant', 'KGRANT', '011.44.1644.429263', '2007/05/24', 'SA_REP',
7000, 0.15, 149, 0),
(179, 'Charles', 'Johnson', 'CJOHNSON', '011.44.1644.429262', '2008/01/04',
'SA_REP', 6200, 0.10, 149, 80),
(180, 'Winston', 'Taylor', 'WTAYLOR', '650.507.9876', '2006/01/24','SH_CLERK',
3200, 0, 120, 50),
(181, 'Jean', 'Fleaur', 'JFLEAUR', '650.587.9877', '2006/02/23','SH_CLERK', 3100,
0, 120, 50),
(182, 'Martha', 'Sullivian', 'MSULLIVA', '650.507.9878', '2007/06/21','SH_CLERK',
2500, 0, 120, 50),
(183, 'Girard', 'Geoni', 'GGEONI', '650.587.9879', '2008/02/03','SH_CLERK', 2800,
0, 120, 50),
(184, 'Nandita', 'Sarchand', 'NSARCHAN', '650.505.1876', '2004/01/27','SH_CLERK',
4200, 0, 121, 50),
(185, 'Alexis', 'Bull', 'ABULL', '650.509.2876', '2005/02/20','SH_CLERK', 4100, 0,
121, 50),
(186, 'Julia', 'Dellinger', 'JDELLING', '650.509.3876', '2006/06/24','SH_CLERK',
3400, 0, 121, 50),
(187, 'Anthony', 'Cabrio', 'ACABRIO', '650.509.4876', '2007/02/07','SH_CLERK',
3000, 0, 121, 50),
(188, 'Kelly', 'Chung', 'KCHUNG', '650.509.1876', '2005/06/14','SH_CLERK', 3800, 0,
122, 50);

insert into locations values

(1000, '1297 Via Cola di Rie', '989', 'Roma', NULL, 'IT'),
(1100, '93091 Calle della Testa', '10934', 'Venice', NULL, 'IT'),
(1200, '2017 Shinjuku-ku', '1689', 'Tokyo', 'Tokyo Prefecture', 'JP'),
(1300, '9450 Kamiya-cho', '6823', 'Hiroshima', NULL, 'JP'),
(1400, '2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US'),
(1500, '2011 Interiors Blvd', '99236', 'South San Francisco', 'California', 'US'),
(1600, '2007 Zagora St', '50090', 'South Brunswick', 'New Jersey', 'US'),
(1700, '2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US'),
(1800, '147 Spadina Ave', 'M5V 2L7', 'Toronto', 'Ontario', 'CA'),
(1900, '6092 Boxwood St', 'YSW 9T2', 'Whitehouse', 'Yukon', 'CA'),
(2000, '40-5-12 Laogianggen', '190518', 'Beijing', NULL, 'CN'),
(2100, '1298 Vileparle (E)', '490231', 'Bombay', 'Maharashtra', 'IN'),
(2200, '12-98 Victoria Street', '2901', 'Sydney', 'New South Wales', 'AU'),
(2300, '198 Clementi North', '540198', 'Singapore', NULL, 'SG'),
(2400, '8204 Arthur St', NULL, 'London', NULL, 'UK'),
(2500, 'Magdalen Centre, The Oxford Science Park', 'OX9 9ZB', 'Oxford', 'Oxford',
'UK'),
(2600, '9702 Chester Road', '9629850293', 'Stretford', 'Manchester', 'UK'),
(2700, 'Schwanthalerstr. 7031', '80925', 'Munich', 'Bavaria', 'DE'),
(2800, 'Rua Frei Caneca 1360', '01307-002', 'Sao Paulo', 'Sao Paulo', 'BR'),
(2900, '20 Rue des Corps-Saints', '1730', 'Geneva', 'Geneve', 'CH'),
(3000, 'Murtenstrasse 921', '3095', 'Bern', 'BE', 'CH'),
(3100, 'Pieter Breughelstraat 837', '3029SK', 'Utrecht', 'Utrecht', 'NL'),
(3200, 'Mariano Escobedo 9991', '11932', 'Mexico City', 'Distrito Federal', 'MX');

alter table job_history drop constraint job_history_pkey;

alter table job_history drop constraint job_history_job_id_fkey;
alter table job_history drop constraint job_history_dept_id_fkey;
alter table job_history drop constraint job_history_emp_id_fkey;

insert into job_history values

(102, '2002/01/13', '2006/07/24', 'IT_PROG', 60),
(101, '1997/09/21', '2001/10/27', 'AC_ACCOUNT', 110),
(101, '2001/10/28', '2005/03/15', 'AC_MGR', 110),
(201, '2004/02/17', '2007/12/19', 'MK_REP', 20),
(114, '2006/03/24', '2007/12/31', 'ST_CLERK', 50),
(122, '2007/01/01', '2007/12/31', 'ST_CLERK', 50),
(200, '1995/09/17', '2001/06/17', 'AD_ASST', 90),
(176, '2006/03/24', '2006/12/31', 'SA_REP', 80),
(176, '2007/01/01', '2007/12/31', 'SA_MAN', 80),
(200, '2002/07/01', '2006/12/31', 'AC_ACCOUNT', 90);

insert into job_grade values

('A', 1000, 2999),
('B', 3000, 5999),
('C', 6000, 9999),
('D', 10000, 14999),
('E', 15000, 24999),
('F', 25000, 40000);

insert into countries values

('AR', 'Argentina', 2),
('AU', 'Australia', 3),
('BE', 'Belgium', 1),
('BR', 'Brazil', 2),
('CA', 'Canada', 2),
('CH', 'Switzerland', 1),
('CN', 'China', 3),
('DE', 'Germany', 1),
('DK', 'Denmark', 1),
('EG', 'Egypt', 4),
('FR', 'France', 1),
('IL', 'Islam', 4),
('IN', 'India', 3),
('IT', 'Italy', 1),
('JP', 'Japan', 3),
('KW', 'Kuwait', 4),
('ML', 'Malaysia', 3),
('MX', 'Mexico', 2),
('NG', 'Nigeria', 4),
('NL', 'Netherlands', 1),
('SG', 'Singapore', 3),
('UK', 'United Kingdom', 1),
('US', 'United States of America', 2),
('ZM', 'Zambia', 4),
('ZW', 'Zimbabwe', 4);

insert into department values

(10, 'Administration', 200, 1700),
(20, 'Marketing', 201, 1800),
(30, 'Purchasing', 114, 1700),
(40, 'Human Resources', 203, 2400),
(50, 'Shipping', 121, 1500),
(60, 'IT', 103, 1400),
(70, 'Public Relations', 204, 2700),
(80, 'Sales', 145, 2500),
(90, 'Executive', 100, 1700),
(100, 'Finance', 108, 1700),
(110, 'Accounting', 205, 1700),
(120, 'Treasury', 0, 1700),
(130, 'Corporate Tax', 0, 1700),
(140, 'Control And Credit', 0, 1700),
(150, 'Shareholder Services', 0, 1700),
(160, 'Benefits', 0, 1700),
(170, 'Manufacturing', 0, 1700),
(180, 'Construction', 0, 1700),
(190, 'Contracting', 0, 1700),
(200, 'Operations', 0, 1700),
(210, 'IT Support', 0, 1700),
(220, 'NOC', 0, 1700),
(230, 'IT Helpdesk', 0, 1700),
(240, 'Government Sales', 0, 1700),
(250, 'Retail Sales', 0, 1700),
(260, 'Recruiting', 0, 1700),
(270, 'Payroll', 0, 1700);

insert into jobs values

('AD_PRES', 'President', 20000, 40000),
('AD_VP', 'Administration Vice President', 15000, 30000),
('AD_ASST', 'Administration Assistant', 3000, 6000),
('FI_MGR', 'Finance Manager', 8200, 16000),
('FI_ACCOUNT', 'Accountant', 4200, 9000),
('AC_MGR', 'Accounting Manager', 8200, 16000),
('AC_ACCOUNT', 'Public Accountant', 4200, 9000),
('SA_MAN', 'Sales Manager', 10000, 20000),
('SA_REP', 'Sales Representatives', 6000, 12000),
('PU_MAN', 'Purchasing Manager', 8000, 15000),
('PU_Clerk', 'Purchasing Clerk', 2500, 5500),
('ST_MAN', 'Stock Manager', 5500, 8500),
('ST_CLERK', 'Stock Clerk', 2008, 5000),
('SH_CLERK', 'Shipping Clerk', 2500, 5500),
('IT_PROG', 'Programmer', 4000, 10000),
('MK_MAN', 'Marketing Manager', 9000, 15000),
('MK_REP', 'Marketing Representatives', 4000, 9000),
('HR_REP', 'Human Resources Representative', 4000, 9000),
('PR_REP', 'Public Relations Representative', 4500, 10500);