I got the first seven, but last 6 are being troublesome, any help would be great
ID: 3648631 • Letter: I
Question
I got the first seven, but last 6 are being troublesome, any help would be greatly appreciated.Directions
Modify Oracle table data using the correct SQL statements. You must create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.
Modification Specifics:
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 (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
8. Due to budget cuts, the IT department was closed. Delete the IT department from your database. Did this work? Why or why not?
9. Explain how you could delete the IT department without deleting all the employees who work for that department.
10. Supplier ASP
Explanation / Answer
Step-by-Step: Using Eraser To make sure a file is truly gone, a number of tools are available. Eraser is a free and easy-to-use solution that will overwrite your private information with random patterns until the data is no longer recoverable. It works with nearly every version of Windows and offers a number of methods of overwriting your data, including methods approved by the Department of Defense. Once installed, Eraser integrates nicely into Windows. Whenever you want to securely erase your data, follow these steps. 1. Navigate to the files or folders that you want to securely erase. 2. Right-click on the files and/or folders and an Eraser menu will appear. 3. Highlight and click Erase in the Eraser menu.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.