Homework

Homework

# Suppose you have created tables in assignment 1 listed

Customer Question
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: 2 years ago.Category: Homework
Show More
Show Less
10/12/2015
Tutor: Mr. Gregory White, Professor replied 2 years ago
Category: Homework
Satisfied Customers: 5,240
Experience: M.A., M.S. Education / Educational Administration
Verified

Hello, my name is Greg.

Is there any other information you can send to see if I can assist on it this for you? If you have any documents you can upload, you can do so to mediafire.com or box.com and share the link here with us.

If I had a model and could provide that as a model (would have to check files to see if I have one), would that be sufficient or are you seeking a fully written new model document?

Customer reply replied 2 years ago
Here What I had that can assit.
Solution of problem 1:CREATE TABLE COMPANY(cid VARCHAR2(12) PRIMARY KEY,company_name VARCHAR2(20),city VARCHAR2(15),state VARCHAR2(15));CREATE TABLE EMPLOYEE(eid VARCHAR2(12) PRIMARY KEY,ename VARCHAR2(20),street VARCHAR2(30),city VARCHAR2(15),state VARCHAR2(15),salary NUMBER(10),cid VARCHAR2(12) REFERENCES COMPANY(cid));CREATE TABLE MANAGERS(mid VARCHAR2(12) PRIMARY KEY,eid VARCHAR2(12) REFERENCES EMPLOYEE(eid));Solution of problem 2:INSERT INTO COMPANYVALUES('C123','Randstand','Glenburnie','Maryland');INSERT INTO COMPANYVALUES('C124','Verizon','Washington','Maryland');INSERT INTO COMPANYVALUES('C125','Infosys','Baltimore','Maryland');INSERT INTO COMPANYVALUES('C126','PWCC','Baltimore','Maryland');INSERT INTO MANAGERS VALUES('M888','E457');INSERT INTO MANAGERS VALUES('M889','E459');INSERT INTO MANAGERS VALUES('M890','E460');INSERT INTO MANAGERS VALUES('M891','E461');INSERT INTO EMPLOYEE VALUES('E456','John','123 newstreet','Baltimore','Maryland',70000,'C123');INSERT INTO EMPLOYEE VALUES('E457','Mary','234 oldstreet','Baltimore','Maryland',65000,'C124');INSERT INTO EMPLOYEE VALUES('E458','Tina','768 faststreet','Washington','Maryland',62000,'C124');INSERT INTO EMPLOYEE VALUES('E459','Robert','231 slowstreet','Frederick','Maryland',72000,'C125');INSERT INTO EMPLOYEE VALUES('E460','Tim','435 newstreet','Frederick','Maryland',66000,'C124');INSERT INTO EMPLOYEE VALUES('E461','Danny','210 oldstreet', 'Washington', 'Maryland', 57000, 'C126');Solution of problem 3:Task 1.SELECT ename FROM EMPLOYEE WHERE city = 'Baltimore';Task 2.SELECT ename FROM COMPANY, EMPLOYEE WHERE COMPANY.cid = EMPLOYEE.cid ANDCOMPANY.city = 'Baltimore';Task 3.SELECT city, COUNT(cid) AS NumberOfCompanies FROM COMPANY GROUP BY city;Task 4.SELECT city, COUNT(cid) AS NumberOfCompanies FROM COMPANY GROUP BY city havingcount(*) >= 2;Task 5.SELECT company_name, COUNT(eid) AS NumberOfEmployees FROM COMPANY, EMPLOYEEWHERE COMPANY.cid = EMPLOYEE.cid GROUP by company_name;Task 6.SELECT ename FROM EMPLOYEE, COMPANY, MANAGERS WHERE COMPANY.cid =EMPLOYEE.cid AND EMPLOYEE.eid = MANAGERS.eid AND COMPANY.company_name ='Verizon';
Tutor: Mr. Gregory White, Professor replied 2 years ago

After going through my resources, I do not have what is necessary to complete at this time.

I am opting out and opening up to the other professionals and messaging a couple who might be able to help.

Someone should be with you shortly.

Tutor: Ingo U, Software Engineer replied 2 years ago
Ingo U, Software Engineer
Category: Homework
Satisfied Customers: 755
Experience: Over 25 years experience in software development. Expert in Microsoft .Net, C#, C++, VB, SQL
Verified

Hi,

are you still looking for an answer to these questions?

Tutor: Ingo U, Software Engineer replied 2 years ago
You can view this answer by clicking here to Register or Login and paying \$3.
Customer reply replied 2 years ago
Thanks for responding. I don't need this question answered any more.
Ingo U, Software Engineer
Category: Homework
Satisfied Customers: 755
755 Satisfied Customers
Experience: Over 25 years experience in software development. Expert in Microsoft .Net, C#, C++, VB, SQL

Ingo U is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

LogicPro

Engineer

5,672 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Tutor

4,549 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

M.S.W. Social Work

2,635 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

Chartered Accountant

2,158 satisfied customers

Experience with chartered accountancy

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
HEALTH, SAFETY, AND NUTRITION FOR THE CHILD 605844RR -
HEALTH, SAFETY, AND NUTRITION FOR THE YOUNG CHILD 605844RR - Preventing Illness and Injuries When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorde… read more
GLENN
Master of Mathematics
330 satisfied customers
FOR Discussion Question 1 • Due Date: Day 2 [post to the
FOR ANGELA Discussion Question 1 • Due Date: Day 2 [post to the Main forum] • Post your response to this question: Consider the statement “psychology has a long past but a short history.” What do you … read more
Seanna
Tutor
1,781 satisfied customers
When I open a word document it has a character string 20 and
When I open a word document it has a character string 20 and places that character after I type each line. This is just a recent problem and. How can have work not insert that character?… read more
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,158 satisfied customers
I need help regarding javascript with custom objects and
I need help regarding javascript with custom objects and constructors. I am having trouble calling an onclick function in a form to an array.… read more
LogicPro
Engineer
Bachelor of Technology
5,672 satisfied customers
Fiscal restraint is defined as: a. Tax hikes or spending
Fiscal restraint is defined as: a. Tax hikes or spending cuts intended to reduce aggregate demand. b. Tax hikes or spending cuts intended to increase aggregate demand. c. Tax cuts or spending hikes in… read more
Chris M.
M.S.W. Social Work
Master's Degree
2,635 satisfied customers
Explain the types purpose and function of materials and
Explain the types purpose and function of materials and equipment needed for the administration of medication via the different routes … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
This week you'll be making the following refinements to the
This week you'll be making the following refinements to the class that you wrote in the last assignment. All the requirements from that class are still in force. For example, all MyStrings must always… read more
LogicPro
Engineer
Bachelor of Technology
5,672 satisfied customers
I have a couple of basic java questions i need answered.
I have a couple of basic java questions i need answered … read more
LogicPro
Engineer
Bachelor of Technology
5,672 satisfied customers
The Use case diagram for a tracking system using clusters of
The Use case diagram for a tracking system using clusters of sensors. I am now in phase 3 and I did all the documentation but I need to deeply understand the logic behind the IoT to proceed correctly … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
I asked a question and will pay but the site asks me to
hi i asked a question and will pay but the site asks me to verify an ammount below 200 usd which i want to but it does not give me the option to do so, please help… read more
GLENN
Master of Mathematics
330 satisfied customers
Which if the following is not included unpaid-in capital?
which if the following is not included unpaid-in capital? common stock pain-in capital-donations stock dividend distributable appropriation per loan agreement … read more
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,158 satisfied customers
A rifle with a longer barrel can fire bullets with a larger
A rifle with a longer barrel can fire bullets with a larger velocity than a rifle with a shorter barrel. A. Explain this using the impulse momentum theorem B. Explain this using the work energy theore… read more
GLENN
Master of Mathematics
330 satisfied customers
This question is just for Dr. Kakonge. This purpose is to
Hello. This question is just for Dr. Donna Kakonge.This purpose is to pay the payment to Dr. Donna Kakonge on 06/16/2017 again because of something wrong about payment on 06/16/2017.The question on 06… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
On Excel contour map want to: 1) rotate series 180 degrees
On Excel contour map want to: 1) rotate series 180 degrees but not category 2) edit series name for all 3) edit legend 4) fill in colour boxes 5) change colour boxes to meet colorirmetric convention.… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
I need to get an answer of the case Conveyor Belt Project.
I need to get an answer of the case Conveyor Belt Project … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
Where is the status bar? Im so sorry to be in a rush but if
where is the status bar? Im so sorry to be in a rush but if i fail my exam i have to redo my year … read more
The-PC-Guy
Bachelor\u0027s Degree
628 satisfied customers
A recent survey found that 73% of all adults over 50 wear
A recent survey found that 73% of all adults over 50 wear sunglasses for driving. In a random sample of 20 adults over 50, what is the mean and standard deviation of those that wear sunglasses?… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
Is anyone familiar with Excel??? The link below will take
Is anyone familiar with Excel??? The link below will take you to my question. It is due 02/14/10 Sunday night , but the sooner the better. You will see "1: Five-Year Sales Projections" that is what I … read more
Stephen, MBA
Master's Degree
166 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less