How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

Ingo, are you able to provide answers to the remaining

Customer Question

Hi Ingo, are you able to provide answers to the remaining two questions? You already provided assistance with the first question in a previous post.

Suppose you have created tables in assignment 1 listed below. Please write an anonymous PL/SQL program for each the following problems. Tables: Company(cid, cname, city, state) /* city is the company’s location, cname is ***** ***** */ Employee(eid, ename,
street, city, state, salary, cid) /* city is where the employee lives*/ Manages(eid, mid) /* mid is manager’s ID*/

Problem 1: Write an anonymous PL/SQL program to compute the sum of 1, 3, 5, 7, 9. You must use a loop. Tip: consider how to update your loop
variable. [30 points]

Problem 2: Use an implicit cursor to print out the MID of manager of Bob. Please handle exceptions. If you do not have Bob as ename in your employee table, use any name you have (e.g., Jeff). [35 points]

Problem 3: Use an explicit cursor
to print out the ename, street, and city of all employees working for Verizon (you can also use any company name you have in your company table if you do not have Verizon as company_name). [35 points]

Submitted: 1 year ago.
Category: Homework