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.

Part a.

1. While arranging capital for their business some managers follow the pecking order theory, can you explain what pecking order theory is and why managers choose such a theory to raise capital?
2. Calculate the rate of return available to shareholders for a company financing $1 million of assets with the following three arrangements:

1. All equity
2. 50% equity, and 50% debt at an interest rate of 12% per annum.
3. 25% equity, and 74% debt at an interest rate of 12% per annum.

The assets are expected to generate earnings before interest of $150,000 per annum in perpetuity.

                                                                                                            (5+3=8 marks)

Part b.

What are the potential advantages and disadvantages to a company’s shareholders if the company increases the proportion of debt in its capital structure?

Part c.

1. From the below figures of Collingwood Public Limited, calculate Weighted Average Cost of Capital (WACC) and annual cashflows required by its capital providers.

2. What are the main difficulties in calculating cost of capital for diversified companies?

Multiple-Step Income Statement

Instructions

Amount Descriptions

Income Statement

Instructions

Use the following information:

Required:

Amount Descriptions

Income Statement

Prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Aeito’s Plumbing Supplies for the year ended December 31, 20--.

Income Statement Instructions

Financial markets can be classified by which of the following?

Owner of the financial asset

All of the above can be classifications of financial markets.

Type of asset traded

Maturity of the financial asset

With the aid of supply and demand diagrams demonstrate that any and all effective price controls in a competitive market will reduce the actual quantity that can be traded (i.e. bought and sold) in that market.

Why was the U.S. trying to spread our influence to other nations? Could we have still traded with nations if they were communist or under the influence of the Soviet Union? Explain.

A company’s auditor believes the per diem cost in Darwin rose significantly between 2005 and 2012. To test this belief, the auditor sampled 51 business trips from the company’s records for 2005; the sample average was $190 per day, with a population standard devi- ation of $18.50. The auditor selected a second random sample of 47 business trips from the company’s records for 2012; the sample average was $198 per day, with a population standard deviation of $15.60. If he uses a risk of committing a Type I error of 0.01, does the auditor find that the per diem average expense in Darwin has gone up significantly?

1. H_o: mu2005 - mu2012 (= ; <= ; >=)  0

H_a: mu2005 - mu2012 (< > ; > ; <) 0

2. Statistical test: (z / t)  test for 2 populations

3. Level of significance (be careful as to one-tailed or two-tailed)

4. Set up critical values (Write the value in the box, include "-" sign if negative, if two values, just write the positive one)

5. Gather sample data: xbar2005 =  ; n2005 = 51 ; sigma2005 = 18.5; xbar2012 = 198; n2012 = 47; sigma2012 =

6. Calculate test statistic (write your answer correct to 2 decimal places)

7. Make statistical conclusion: (Reject / Do not reject)  the null hypothesis. There is (sufficient/insufficient)   evidence that the per diem expense has rose significantly from 2002 to 2009 at 1% level of significance.

Case one:
Intergovernmental working group of experts on international
standards of accounting and reporting
1. What are International Financial Reporting Standards (IFRS)?
2. Many concerns are expressed in this article. List three factors that you think
are causing concern about the impact of adoption of IFRS.
3. Consider each of the three factors you mentioned in response to question 2.
(a) Is there empirical evidence to support the factor?
(b) Is the analysis leading from the factor to the concerns about adoption
of IFRS scientific or naturalistic in its approach? Explain your answer.

Case two:
1. On 1 January 2005 Australia adopted IASB standards.
(a) Do you agree with this change? Why or why not?
(b) Who stands to gain from Australia’s adoption of IASB standards?
Explain.
(c) Who stands to lose from Australia’s adoption of IASB standards?
Explain.
From 1 January 2005 the AASB will issue Australian equivalents to IFRS.
This process involves the AASB issuing IASB exposure drafts as exposure
drafts in Australia. Constituents can provide comments on standards to the
AASB and IASB. Final standards issued by the IASB are subsequently
issued in Australia with any additional paragraphs necessary to make the
standards suitable for public sector and not-for-profit entities.
Requirement:
Students are required to answer questions in an essay format (introduction, body,
conclusion

The following accounts are taken from the December 31, Year 4 financial statements of a company.

What is the amount of retained earnings on the Balance Sheet at the end of Year 4?