Reference no: EM13922294

A new manager was recently hired along with 5 employees who will work under her.

The President of our company has created a new department for her to head as well.

You can assume that all the new employees were hired today. Make sure your changes get saved to the database.

Information:

New Employees:

First Name	Last Name	Credit Limit	Phone Number
Jane	Smith	15.00	7890
Martha	Woods	20.25
Bill	Bourne
Mike	Oleni	33.33	3333
C	Etter	43

New Manager:

Rose Hamby is the manager of all the employees above.  Her information is below:

First Name	Last Name	Credit Limit	Phone Number	Manager Name
Rose	Hamby	14.00	3433	Susan Brown

The new department that was created for Rose is as follows:

Department Code	Department Name
IT	Information Technology

Write insert statements to insert the data into the tables above. Show all the insert statements you used, along with the order they were run in. Use the seq_employee_id SEQUENCE to get the employee_id. Do not hard-code the manager_id value in your insert statements.

After all the data is entered, run selects to show that the data is actually in the database. Show those screenshots below.