This is t a relational database please write SQL queries to solve the listed questions.

The database is a variation of the “Movie Database” . There are several differences in it, so look it over carefully before writing your SQL queries

Notes:

• TheaterNum, MovieNum, and ActorNum are numeric primary key fields in their respective tables. Movie and actor names are not assumed to be unique unless specified otherwise in a question.
• In the THEATER table, Capacity is the number of seats in a theater.
• In the MOVIE table, Year is the year a movie was filmed.
• The ACTED IN table lists all of the actors who acted in a movie. The Star field can have the values Y (yes) or N (no). Assume there is only one star in each movie.

CITY

THEATER

MOVIE

SHOWINGS

DIRECTOR

PRODUCER

ACTOR

PREVIOUSJOB

ACTEDIN

NEWSPAPER

REVIEWER

REVIEW

Questions

Remember to follow all of the instructions listed on the first page.

1. Which theater(s) in Tennessee have the largest capacity?

2. How many reviews were written for each movie directed by John Carter that were filmed in the period 2014 to 2019

3. List the phone number of every theater in Tennessee. Order the results by theater number.

4. What was the total revenue generated by movies made in 2015 that were both directed by James Smith and produced by Mary Jones?

5. Assume there is only one movie titled, “The Matrix.” Who reviewed it?

6. List the cities in Tennessee that have theaters with capacities of at least 200 seats. List the cities in alphabetic order.

7. Which movies have generated more revenue than the movie directed by John Carter in 2010 that generated the most revenue of the movies he directed that year?

8. Which theaters in Tennessee, Arkansas, or Mississippi (you may use 2-letter abbreviations) showed movies whose titles began with any of the letters R, S, or T? List the theaters in numeric order.

9. Who is the oldest actor who starred in a movie made between 1995 and 2005 that was both directed by James Smith and produced by Mary Jones?

10. What was the total revenue generated by movies produced by each producer from 2010 to 2018 that starred an actor who is currently under 40 years of age? Only include producers whose movies generated more than a total of $75,000,000.

1. Suppose the data on today’s and future expected interest rates is given:

a) Calculate today’s interest rates on 2-year, 3-year and 4-year bonds using the expectations hypothesis. Use these yields to construct a yield curve and plot it. What kind of shape does it have?

b) Now, suppose term premiums for 2-year, 3-year and 4-year bonds are 0.2%, 0.3% and 0.4%, respectively. Recalculate today’s interest rates on 2-year, 3-year and 4-year bonds using the liquidity premium theory. Use the yields to plot the yield curve on the same graph as expectations hypothesis yield curve from part (a). What do you notice?

Question 6 (a) A hospital cafeteria proposes to serve 4 main entrees. For planning purposes, the manager expects that the proportions of each that will be selected by his customers will be: Selection Proportion Chicken 0.4 Roast beef 0.2 Steak 0.1 Fish 0.3 Of the first 100 customers, 44 selected chicken, 25 selected roast beef, 13 select steak, and 18 selected fish. Should the manager revise his estimates? Use α= 0.01.

(b) Five brands of orange juice are displayed side by side in several supermarkets in Hobart. It was noted that in one day, 180 customers purchased orange juice. Of these, 30 picked Brand A, 40 picked Brand B, 25 picked Brand C, 35 picked Brand D, and 50 picked Brand E. In this city, can you conclude at the 5% significance level that there is a preferred brand of orange juice? (9 marks

Part V. 1. Events G and H are defined on the sample space. If P(G) = 0.3, P(H) = 0.2, and P(G ! H) = 0.1 a) Are G and H independent? Explain. __________________________________________________________________________ b) Are G and H mutually exclusive? Explain. ___________________________________________________________________________ 2. The classical probability concept applies only when all possible outcomes are ______________________. 5 3. If A is the event that I win the lottery and B is the event that I go on vacation, then P(B | A) can be described in words as the probability that ______________________________________________________________. 4. A restaurant menu has 8 main courses, 5 appetizers, 6 desserts, and 4 beverages. The number of ways that a patron can select a meal with one appetizer, one main course, one dessert and one beverage is ________________________________________________. 5. The number of 5-player basketball teams that can be formed from a group of 11 players is _______________________________________________. 6. How many ways can letters of PROBABILITY be arranged? _____________________________________________.

1. Suppose the data on today’s and future expected interest rates is given:

a) Calculate today’s interest rates on 2-year, 3-year and 4-year bonds using the expectations hypothesis. Use these yields to construct a yield curve and plot it. What kind of shape does it have?

b) Now, suppose term premiums for 2-year, 3-year and 4-year bonds are 0.2%, 0.3% and 0.4%, respectively. Recalculate today’s interest rates on 2-year, 3-year and 4-year bonds using the liquidity premium theory. Use the yields to plot the yield curve on the same graph as expectations hypothesis yield curve from part (a). What do you notice?

Two different designs on a new line of winter jackets for the coming winter are available for your manufacturing plants. Your profit (in thousands of dollars) will depend on the taste of the consumers when winter arrives. The probability of the three possible different tastes of the consumers and the corresponding profits are presented in the following table.

Probability Taste Design A Design B

0.2 more conservative 180 520

0.5 no change 230 310

0.3 more liberal 350 270

1) If you decide to choose Design A for 70% of the production lines and Design B for the remaining production lines, what is the coefficient of variation of your investment?

2) If you decide to choose Design A for 90% of the production lines and Design B for the remaining production lines, what is the expected profit?

3) If you decide to choose Design A for 90% of the production lines and Design B for the remaining production lines, what is the risk of your investment ?

An activated sludge process with an aeration basin volume of 0.3 MG is treating wastewater with the average daily flow of 2 MGD. The raw sewage entering the treatment plant has an average BOD5 of 400 mg/L. The primary treatment removes 25% of BOD5 and the subsequent activated sludge process is designed to remove 90% of BOD5.

Given:

Plant effluent BOD5 concentration = 30 mg/L

Biomass concentration in the aeration tank = 2,000 mg/L

Biomass concentration in the plant effluent = 20 mg/L

Biomass concentration in the recycle (RAS) = 8,000 mg/L

Flow rate of waste sludge (WAS) = 0.025 MGD

Endogenous decay rate (kd) = 0.01 day-1

a) Calculate the MCRT of the process.

b) Determine the yield coefficient, Y.

c) If µnet, nitrifiers = 0.2/day, would you expect to get nitrification in this system? Briefly describe why or why not and show any supporting calculations.

Use the following table to answer questions 1 - 6:

1. What is the expected return for asset A?

2. What is the expected return for asset B?

3. What is the standard deviation for asset A?

4. What is the standard deviation for asset B?

5. What is the expected return of a portfolio that has 70% in Asset A and 30% in Asset B?

6. The standard deviation of the 70% A and 30% B portfolio most likely should: