Express HelpLine

ExpressHelpLine is the largest online question and Expert answer site.
Thousands of Verified Experts/Tutors are online round the clock.

Question (Category: computer science)
note questions 1 and 4 have been answered. 1. 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 manger_id value in your insert statements. 2. mike olenikrsquos name was spelled ihi i'm behind in a major way with sql, i've been having problems, so i need major help from you great help at cramsters. thanks directions modify oracle table data using the correct sql statements. you must create the statements in oracle by using the following steps (sql gt sql commands gt 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 ncorrectly. change his record so that his last name is spelled correctly.(olenik). make sure your changes get saved to the database. 3. fred campbell asked for a transfer from the shipping department to the it department. his request was approved. update the database to reflect this change. 4. c. etterrsquos first name should have been cynthia. update the database to reflect this change. 5. for some unknown reason, hr decided to change the hire date of all the employees that were added today, to tomorrow (09132005). update the database to reflect this change. make sure your changes get saved to the database. 6. bill bourne has now received a phone number and credit limit. they are 4553 and $35.00 respectively. update the database to reflect this change. 7. bill bourne spent more than his credit limit and was fired. show how you would delete him from the database. 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 asprsquos has decided to raise their prices. they raised the price of all their foods by a $1. update the database to show this change.


Answer by Matt D. (Purchased 2 times and rated )