Top is extra info. Information: New Employees (using table l_employees): First N
ID: 3648676 • Letter: T
Question
Top is extra info.Information:
New Employees (using table l_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 (using table l_employees):
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 (using table l_department):
Department Code Department Name
IT Information Technology
1. Due to budget cuts, the IT department was closed. Delete the IT department from your database. Did this work? Why or why not?
Explanation / Answer
Ya.It has to work.. Sql Command:- delete from l_department where Department Code='IT';