Please write an anonymous PL/SQL program which uses an implicit cursor to print out the score and rank of team 'Mad Scientists' in the competition 'Science Olympiad Regional Baltimore'. Please handle exceptions.
Problem 4: [15 points] Please write an anonymous PL/SQL program to print out the names of students and their school names for the team that won the first place (rank=1) in Science Olympiad Maryland State (name of a competition).

drop table school cascade constraints;
drop table student cascade constraints;
drop table team cascade constraints;
drop table competition cascade constraints;
drop table team_result cascade constraints;

create table school
(sid int, -- school id
sname varchar(50), -- school name
primary key(sid));

insert into school values(1, 'Catonsville High');
insert into school values(2, 'MarriottsRidge High');

create table team
(tid int, --- team id
tname varchar(50), --- team name
primary key(tid)
);

insert into team values(1,'Science Genius');
insert into team values(2,'Super robot');
insert into team values(3,'Mad Scientists');
insert into team values(4,'Little Eisenstein');

create table student
(stid int, -- student id
stname varchar(50), --- student name
sid int, --- school id
tid int, --- team id
grade int, --- grade
primary key(stid),
foreign key(sid) references school,
foreign key(tid) references team);

insert into student values(1, 'Anna', 1, 1, 11);
insert into student values(2, 'Erica', 1, 1, 12);
insert into student values(3, 'David', 1, 1, 11);
insert into student values(4, 'Ravi', 1, 2, 11);
insert into student values(5, 'Ali', 1, 2, 12);
insert into student values(6, 'Cathy', 1, 2, 11);
insert into student values(7, 'Grace', 2, 3, 11);
insert into student values(8, 'Megan', 2, 3, 12);
insert into student values(9, 'Jeff', 2, 3, 11);
insert into student values(10, 'Ryan', 2, 4, 11);
insert into student values(11, 'Ron', 2, 4, 12);
insert into student values(12, 'Ella', 2, 4, 11);

create table competition
(cid int, --- competition id
cname varchar(50), --- competition name
cdate date, --- competition date
primary key (cid));

insert into competition values (1, 'Science Olympiad Regional Baltimore',
date '2020-2-28');
insert into competition values (2, 'Science Olympiad Maryland State',
date '2020-4-1');

create table team_result
(tid int, --- team id
cid int, --- competition id
score number, --- score of the team in the competition
rank int, --- teams ranking in the competition, smaller the better
primary key(tid,cid),
foreign key(tid) references team,
foreign key(cid) references competition);
insert into team_result values(1, 1, 95, 2);
insert into team_result values(2, 1, 90, 3);
insert into team_result values(3, 1, 89, 4);
insert into team_result values(4, 1, 99, 1);
insert into team_result values(1, 2, 98, 2);
insert into team_result values(4, 2, 100, 1);  

13. In terms of indifference curves, an increase in total utility is represented by a:

14. A consumer has a budget of $60 and wishes to purchase both products A and B. The price of product A is $8.42, while the price of product B is $26.32. The marginal utilities of the two products are provided in the table below.

The optimal bundle is ____ of product A and ____ of product B.

Rudolph has a budget of $22 to spend on rice ( R) and chicken nuggets ( N). The price of rice is $4.04 per pound, and the price of chicken nuggets is $3.28 per unit. The table below shows the marginal utilities that the consumer gets from the different quantities of both.

What is the optimal bundle of rice and chicken nuggets ( Q_R, Q_N) for Rudolph? ( Q_R, Q_N) =

A community health association is interested in estimating the average number of maternity days women stay in the local hospital. A random sample is taken of 36 women who had babies in the hospital during the past year. The following numbers of maternity days each woman was in the hospital are rounded to the nearest day. 3 3 4 3 2 5 3 1 4 3 4 2 3 5 3 2 4 3 2 2 1 6 3 4 3 3 5 2 3 3 3 5 4 3 5 4 Use these data and a population standard deviation of 1.12 to construct a 98% confidence interval to estimate the average maternity stay in the hospital for all women who have babies in this hospital.

1- Use calculus to find the absolute maximum and minimum values of the following functions on the given intervals. Give your answers exactly and show supporting work.

f(x) = (7x − 1)e^−2x on [0, 1]

f(x) = x^4 − 2x^2 + 4 on [0, 2]

f(x) = x^3 − 2x^2 + x + 1 on [0, 1]

Round answers to 5 decimal places. Suppose there are two consumers, A and B, and two goods, X and Y. Consumer A is given an initial endowment of 3 units of good X and 7 units of goodY. Consumer B is given an initial endowment of 8 units of good X and 5 units of good Y. ConsumerA’s utility function is given by:UA(X, Y) =X^1/2 Y^1/2 and Consumer B’s utility function is given byUB(X, Y) =X^1/5 Y^4/5. Therefore, the marginal utilities are as follows:

MU X/A= 1/2X^-1/2 Y^1/2

MU Y/A= 1/2X^1/2 Y^−1/2

MU XB= 1/5X^−4/5 Y^3/4

MU YB= 4/5X^1/5 Y^−1/5

1) How much of each good does consumer A demand in equilibrium?

2) How much of each good does consumer B demand in equilibrium?

3) What is the MRS for consumer B at the competitive equilibrium?

4) Illustrate the situation in an Edgeworth Box. Be sure to label your box carefully andaccurately. Identify the initial endowment and label it M. Identify the competitive equilibrium and label it C. Draw the budget constraint that each consumer faces and identify the values where it intersects the perimeter of the Edgeworth Box (there are 2 different intercepts to identify for each consumer).

Consider the following time series data.

Please show steps to solve using Excel.

Use Tornadoes data and your statistical expertise to answer the questions: Is it reasonable to claim that on average October has less than four tornado-related deaths (per year)?

9. What test/procedure did you perform?

a. One-sided t-test

b. Two-sided t-test

c. Regression

d. Confidence interval

10. What is the P-value/margin of error?

a. 0.723595771

b. 1.8

c. 3.684118249

d. 1.10683165

e. None of these

11. Statistical Interpretation

a. Since the confidence interval of 3.68411 is below 4, we are confident that the number of tornado-related deaths is below 4.

b. Since the P-value is not small, we cannot claim that the number of tornado-related deaths is below 4.

c. Since confidence interval is above 4, we cannot claim that the number of tornado-related deaths is below 4.

d. None of these

12. Conclusion

a. Yes, I am confident that the above assertion is reasonable.

b. No, we cannot claim that the above assertion is reasonable.

which of the following sets of quantum numbers (n,l,m) is not possible? a. 3 3 -3 +1/2 b. 2 1 -1 +1/2 c. 2 0 0 +1/2 d. 2 1 0 +1/2 e. 4 2 -1 -1/2

What are the products of gametogenesis?

A. Females- 1 egg ; Males- 2 sperm

B. Females – 4 eggs ; Males- 4 sperm

C. Females- 4 eggs ; Males- 1 sperm

D. Females- 1 egg ; Males- 4 sperm