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.