1. Based on the tables below, write SQL command to perform the following tasks for MySql:

1. Create SALESREP and CUSTOMER tables
2. Create primary and foreign keys as appropriate. The custNo should use a surrogate key as the primary key with auto-increment
3. increase the balance of the Gonzales account by $100 to a total of $450?
4. Find an average customer balance
5. Display the name of the sales representative and the name of the customer for each customer that has a balance greater than 400

SALESREP

CUSTOMER

Between about December 2007 and June 2009, the United States was considered to be in a recession. The U.S. Gross Domestic Product fell approximately 3% from the third quarter of 2008 to the third quarter of 2009. Also, during December 2007 and June 2009, the Standard and Poor’s 500 index dropped by 38% and the unemployment rate climbed from 5% to 9.5%.

The macroeconomic situation affected almost all companies since higher unemployment affected personal consumption, which dropped from 10,140.3 Billion Dollars in Aug 2008 to 9,807 Billion Dollars in June 2009, a drop of 3.8 percent.

Starbucks is one of the companies affected by the December 2007 recession. The following table shows several ratios for Starbucks corresponding to the years 2006, 2007, and 2008. Use a stock price of 10.9 dollars per share for the year 2009.

By using the financial statements provided, calculate the ratios presented in the table for the year 2009 and answer the following questions:

a-       Were sales per dollar of assets impacted by the recession?

b-      which ratio shows the impact of the recession on sales per dollar of assets?

c-       Did the company operating profit margin increased, decreased, or was the same, between the years 2007 and 2009?

d-      Did the mix of debt and equity changed for Starbucks between the years 2007 and 2009?

e-      In what ratio can you see the change in the mix of debt and equity reflected?

f-        Did the value added by management, reflected in market to book ratio, increased or decreased between the years 2007 and 2009?

g-       Did the quick ratio increase or decrease between the years 2007 and 2009?

h-      Explain why you expect the quick ratio to increase or decrease during a recession?

i-        Use the ratios for the years 2007 and 2009 to explain if, in your view, Starbucks is in a better or worse situation in the year 2009 due to the recession.

j-        What areas should Starbucks improve for the years 2010 onwards, if any?

Estimate how many deaths there are annually from tornado and drowning in the United States. Provide an actual number in your answer and explain statistically how you came to that answer.

Info:

DROWNINGS:

From 2005-2014, there were an average of 3,536 fatal unintentional drownings (non-boating related) annually in the United States — about ten deaths per day.¹ An additional 332 people died each year from drowning in boating-related incidents.

TORNADOS:

The difference between IFRS and GAAP are well documented and in the 2000's and early 2010's several convergence projects were undertakem by IASB and FASB in the effort to align the two. One of the projects relate to revenue recongnition and specifically that of construction contracts. You are to critically reflect on the cponvergence projects taking into account the following:

(a) the differences in revenue recognition (of construction contracts) between IFRS and GAAP?

(b) Why it is importatant to consider the differences in IFRS and GAAP in general?

(c) Potential for lobbying to take place in final outcome of convergence projects.

Extensions of Demand and Supply Analysis

1. Graph the accompanying demand data, and then use the midpoint formula for Ed to determine price elasticity of demand for each of the four possible $1 price changes. What can you conclude about the relationship between the slope of a curve and its elasticity? Explain in a
   nontechnical way why demand is elastic in the northwest segment of the demand curve and inelastic in the southeast segment.

2- Calculate total-revenue data from the demand schedule in question 2. Graph total revenue below your demand curve. Generalize about the relationship between price elasticity and total revenue.

As the population ages, there is increasing concern about accident-related injuries to the elderly. An article reported on an experiment in which the maximum lean angle—the farthest a subject is able to lean and still recover in one step—was determined for both a sample of younger females (21–29 years) and a sample of older females (67–81 years). The following observations are consistent with summary data given in the article:

Calculate the test statistic and determine the P-value. (Round your test statistic to two decimal places and your P-value to three decimal places.)

A perfectly competitive firm sells pencils for $3.00 per box with marginal revenues of .60 per box. The following is its production level and the marginal costs associated with each level:

• 1 box, MC of .10; ATC = .50
• 20 boxes, MC of .05; ATC = .30
• 30 boxes, MC of .15; ATC = .45
• 40 boxes, MC of .58; ATC = .50
• 50 boxes, MC of .68; ATC = .68

My answer =The firm is operating in perfectly competitive industry. The Marginal Revenue = $ 0.60 per box thus, the firm maximizes profit at the point where, MR = MC.
The firm will maximize profit at MC = $ 0.58
40 boxes, MC = $ 0.58 and ATC = $ 0.50

* What is the firms profit maximization level and what is profit at that level? Also, what factors might contribute to rising costs in the short and long run?

Monopsonistic exploitation is

A.the difference between the number of workers employed by a competitive firm and those employed by a monopsonist.

B. equal to the marginal factor cost of the monopsonist.

C. the difference between the marginal revenue product of labor and the wage paid by the monopsonist.

D. the difference between the monopsony wage and the competitive wage.

Use the given information to find the number of degrees of freedom, the critical values 2χ2L and χ2R, and the confidence interval estimate of sigma σ. It is reasonable to assume that a simple random sample has been selected from a population with a normal distribution.

Nicotine in menthol cigarettes 98​% ​confidence; n= 27​, s=0.27 mg.

df=

2χ2L=___

​(Round to three decimal places as​ needed.)

2χ2=____

​(Round to three decimal places as​ needed.)

The confidence interval estimate of σ is ___mg < σ <___mg.

​(Round to two decimal places as​ needed.)

a. What is the expected return of investing equally in all three assets M, N, O?

b. What is the expected return of investing in asset M alone?

c. What is the standard deviation of the portfolio that invests equally in all three assets?

d. What is he standard deviation of asset M?