Sample Tables to be downloaded:

Employee Table:

create table employee (employee_id int,last_name varchar2(10),last_name varchar2(10),first_name varchar2(10),address varchar2(20),city varchar2(10),state varchar2(10),zipcode varchar2(6),salary int,department_id int);

insert into employee (employee_id,last_name,first_name,address,city,state,zipcode,salary,department_id) values

(1,'Lee','Minho','1420 Lexington Plaza','Seoul','AZ','50266',2000,1);

insert into employee (employee_id,last_name,first_name,address,city,state,zipcode,salary,department_id) values (2,'Kim','Joo','555 Lexington Plaza','Seoul','FL','50100',3000,2);

insert into employee (employee_id,last_name,first_name,address,city,state,zipcode,salary,department_id) values (3,'Karl','Max','666 Lexington Plaza','Seoul','FL','50100',4000,3);

insert into employee (employee_id,last_name,first_name,address,city,state,zipcode,salary,department_id) values (4,'Park','Mike','100 Lexington Plaza','Seoul','NJ','40100',5000,2);

Department Table:

create table department (department_id int,department_name varchar2(10),dept_phone_number int);

insert into department (department_id,department_name,dept_phone_number) values (1,'Dept 1',5157700001); insert into department (department_id,department_name,dept_phone_number) values (2,'Networking',5157700002); insert into department (department_id,department_name,dept_phone_number) values (3,'Dept 3',5157700003);