Questions
Suppose that the demand curve for barley can be characterized by the equation P = 100...

Suppose that the demand curve for barley can be characterized by the equation P = 100 - 2Qd. Suppose further that price was $10.00 and a $10.00 tax is imposed on the market. a) How many barleys would be purchased at a price of $10.00? After tax? b) What is the amount of tax revenue generated by the tax? c) How much excess burden is generated by the tax? d) What is the amount of consumer surplus before and after the tax? What is the difference in consumer surplus? Is it equal to excess burden plus the tax revenue?

In: Economics

A rocket takes off vertically from the launchpad with no initial velocity but a constant upward...

A rocket takes off vertically from the launchpad with no initial velocity but a constant upward acceleration of 2.25 m/s2 . At 15.4s after blastoff, the engines fail completely so the only force on the rocket from then on is the pull of gravity (free fall). a) What is the maximum height the rocket will reach above the launchpad? b) How fast is the rocket moving at the instant before it crashes onto the launchpad? c) How much longer after the engines fail does it take for the rocket to crash on the launchpad?

In: Physics

A 11.7kg weather rocket generates a thrust of 200N . The rocket, pointing upward, is clamped...

A 11.7kg weather rocket generates a thrust of 200N . The rocket, pointing upward, is clamped to the top of a vertical spring. The bottom of the spring, whose spring constant is 550N/m , is anchored to the ground.

A) Initially, before the engine is ignited, the rocket sits at rest on top of the spring. How much is the spring compressed?

B)After the engine is ignited, what is the rocket's speed when the spring has stretched 32.0cm ?

C)For comparison, what would be the rocket's speed after traveling this distance if it weren't attached to the spring?

In: Physics

The data shows process completion times in hours of a manufacturing plant prior to and after...

The data shows process completion times in hours of a manufacturing plant prior to and after a scheduled routine maintenance operation:

A.) Evaluate the assumption of normality of the datasets

B.) State and test the hypothesis of equal variance in the test populations

C.) State and test the hypothesis that the maintenance operation has any effect on the processing time

Before After
4.17 6.31
5.58 5.12
5.18 5.54
6.11 5.5
4.5 5.37
4.61 5.29
5.17 4.92
4.53 6.15
5.33 5.8
5.14 5.26

In: Math

Exercise 5.5 PART A Copy or cut and paste program P5_2.cpp (located below) to a new...

Exercise 5.5

PART A

Copy or cut and paste program P5_2.cpp (located below) to a new program called ex55.cpp. Make PI a constant value. Compile and run the program for the following values:

r = 2 cm, h = 10 cm

The correct answer should be:
      The cross-section area of the cylinder is 3.89556 inch-sq
      The side area of the cylinder is 19.4778 inch-sqr

Did you get the correct answer? You didn't! Explain the reason for this logic error in your report. Now add the instruction that fixes the problem (yes, you need just one instruction) and save your file in ex55.cpp file.   HINT: r=r*0.3937; //converting r to inch

PART B

Modify the ex55.cpp to include a new function called total_area that computes the total surface area of a cylinder. The total surface area is the sum of the side area and cross-section area. Call your new program ex56.cpp.

For r=2 and h=10, the total area must be:  23.373383 inch-sqr.

Program P5_2.cpp:

// P 5_2.cpp This program illustrates the local and global variables and call-by-value.
// This program computes the side area and the cross section area of a cylinder
#include
#include
using namespace std;

//Let’s declare first any global constant, if any required

// This variable is defined globally, i.e. it is known to all functions in this program as PI

// To declare a global constant you must write it outside the main() function

const double PI = 3.14159;  

//Now we declare any programmer defined function

double cross_area(double r);                          // Function prototype for function cross_area
double side_area(double r, double h);            // Function prototype for function Side_area

// Start defining the main function

int main(void)
{
     double h, r; //variables local to the main function

      cout << "Enter the radius and the height of the cylinder in Cm ";
      cin >> r >> h;
      cout << endl;
      cout << "Before I do any computation or call any function, I want to let you know that \n";
      cout << "you have entered r = " << r << " and h = " << h << "." << endl;
      cout << "I am planning to use inch, thus in the first function, I will convert r, and " << endl;
      cout << "in the second one I will convert h \n";

      cout << "The cross section area of the cylinder is " << cross_area(r) << " inch-sqr" << endl;
      cout << "The side area of the cylinder is " << side_area(r,h) << " inch-sqr \n\n";

      return 0;
}

// Definition of all programmer defined functions

double cross_area(double r)
{
     //Cross section area includes the disks at the bottom and the top
      r = r * 0.3937; // converting r to inch
      return 2*PI*pow(r,2);
}

double side_area(double r, double h)
{
      double area; //variable local to side_area function
      h = h * 0.3937; // converting h to inch
      area = 2*PI*r*h;
      return area;
}

In: Computer Science

When a country has a comparative advantage in the production of a good, it means that...

When a country has a comparative advantage in the production of a good, it means that it can produce this good at a lower opportunity cost than its trading partner. Then the country will specialize in the production of this good and trade it for other goods.

The following graphs show the production possibilities frontiers (PPFs) for Freedonia and Lamponia. Both countries produce lemons and sugar, each initially (i.e., before specialization and trade) producing 24 million pounds of lemons and 12 million pounds of sugar, as indicated by the grey stars marked with the letter A.

Freedonia08162432404856646456484032241680SUGAR (Millions of pounds)LEMONS (Millions of pounds)PPFA

Lamponia08162432404856646456484032241680SUGAR (Millions of pounds)LEMONS (Millions of pounds)PPFA

Freedonia has a comparative advantage in the production of   , while Lamponia has a comparative advantage in the production of   . Suppose that Freedonia and Lamponia specialize in the production of the goods in which each has a comparative advantage. After specialization, the two countries can produce a total ofmillion pounds of sugar and

million pounds of lemons.

Suppose that Freedonia and Lamponia agree to trade. Each country focuses its resources on producing only the good in which it has a comparative advantage. The countries decide to exchange 16 million pounds of lemons for 16 million pounds of sugar. This ratio of goods is known as the price of trade between Freedonia and Lamponia.

The following graph shows the same PPF for Freedonia as before, as well as its initial consumption at point A. Place a black point (plus symbol) on the graph to indicate Freedonia's consumption after trade.

Note: Dashed drop lines will automatically extend to both axes.

FreedoniaConsumption After Trade08162432404856646456484032241680SUGAR (Millions of pounds)LEMONS (Millions of pounds)PPFA

The following graph shows the same PPF for Lamponia as before, as well as its initial consumption at point A.

As you did for Freedonia, place a black point (plus symbol) on the following graph to indicate Lamponia's consumption after trade.

LamponiaConsumption After Trade08162432404856646456484032241680SUGAR (Millions of pounds)LEMONS (Millions of pounds)PPFA

True or False: Without engaging in international trade, Freedonia and Lamponia would have been able to consume at the after-trade consumption bundles. (Hint: Base this question on the answers you previously entered on this page.)

True

False

In: Economics

Net Income Planning Superior Corporation sells a single product for $60 per unit, of which $36...

Net Income Planning Superior Corporation sells a single product for $60 per unit, of which $36 is contribution margin. Fixed costs total $72,000 and net income before income tax is $28,800.

Determine the following


a The present sales volume in dollars. $ Answer


b. The break-even point in units. Answer

units
c. The sales volume in units necessary to attain a net income before income tax of $39,600. Answer

units
d. The sales volume in units necessary to attain a net income before income tax equal to 20% of sales revenue. Answer

units
e. The sales volume in units necessary to attain an after-tax net income of $43,200 if the tax rate is 40%. Answer

units

In: Accounting

Question text Forecasting and Estimating Share Value Using the DCF Model Following are the income statement...

Question text

Forecasting and Estimating Share Value Using the DCF Model
Following are the income statement and balance sheet for Intel Corporation.

INTEL CORPORATION
Consolidated Statements of Income
Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008
Net revenue $ 44,123 $ 35,127 $ 37,586
Cost of sales 15,132 15,566 16,742
Gross margin 28,991 19,561 20,844
Research and development 6,576 5,653 5,722
Marketing, general and administrative 6,309 7,931 5,452
Restructuring and asset impairment charges -- 231 710
Amortization of acquisition-related intangibles 18 35 6
Operating expenses 12,903 13,850 11,890
Operating income 16,088 5,711 8,954
Gains (losses) on equity method investments, net* 117 (147) (1,380)
Gains (losses) on other equity investments, net 231 (23) (376)
Interest and other, net 109 163 488
Income before taxes 16,545 5,704 7,686
Provisions for taxes 4,581 1,335 2,394
Net income $ 11,964 $ 4,369 $ 5,292

*This should be considered as operating income.

INTEL CORPORATION
Consolidated Balance Sheets
As of Year-Ended (In millions, except par value) Dec. 25, 2010 Dec. 26, 2009
Assets
Current assets
Cash and cash equivalents $ 5,498 $ 3,987
Short-term investments 11,294 5,285
Trading assets 5,093 4,648
Accounts receivables, net 2,867 2,273
Inventories 3,757 2,935
Deferred tax assets 1,488 1,216
Other current assets 1,614 813
Total current assets 31,611 21,157
Property, plant and equipment, net 17,899 17,225
Marketable equity securities 1,008 773
Other long-term investments** 3,026 4,179
Goodwill 4,531 4,421
Other long-term assets 5,111 5,340
Total assets $63,186 $53,095
Liabilities
Current liabilities
Short-term debt $38 $172
Accounts payable 2,190 1,883
Accrued compensation and benefits 2,888 2,448
Accrued advertising 1,007 773
Deferred income on shipments to distributors 622 593
Other accrued liabilities 2,482 1,722
Total current liabilities 9,227 7,591
Long-term income taxes payable 190 193
Long-term debt 1,677 2,049
Long-term deferred tax liabilities 926 555
Other long-term liabilities 1,236 1,003
Total liabilities 13,256 11,391
Stockholders' equity:
Preferred stock, $0.001 par value -- --
Common stock, $0.001 par value, 10,000 shares authorized; 5,581 issued and 5,511 outstanding and capital in excess of par value 16,178 14,993
Accumulated other comprehensive income (loss) 333 393
Retained earnings 33,419 26,318
Total stockholders' equity 49,930 41,704
Total liabilities and stockholders' equity $ 63,186 $ 53,095

** These investments are operating assets as they relate to associated companies.

(a) Compute Intel's net operating assets (NOA) for year-end 2010.
2010 NOA = ?



(b) Compute net operating profit after tax (NOPAT) for 2010, assuming a federal and state statutory tax rate of 37%.

HINT: Gains/losses on equity method investments are considered operating income. Round your answer to the nearest whole number.
2010 NOPAT = ?



(c) Forecast Intel's sales, NOPAT, and NOA for years 2011 through 2014 using the following assumptions:

Sales growth 10%
Net operating profit margin (NOPM) 26%
Net operating asset turnover (NOAT) at fiscal year-end 1.50

Forecast the terminal period value using the assumptions above and assuming a terminal period growth of: 1%.

INTC Reported Forecast Horizon Terminal
($ millions) 2010 2011 Est. 2012 Est. 2013 Est. 2014 Est. Period
Sales (rounded two decimal places) $Answer

Incorrect
Mark 0.00 out of 1.00

$Answer

Incorrect
Mark 0.00 out of 1.00

$Answer

Incorrect
Mark 0.00 out of 1.00

$Answer

Incorrect
Mark 0.00 out of 1.00

$Answer

Incorrect
Mark 0.00 out of 1.00

$Answer

Incorrect
Mark 0.00 out of 1.00

Sales (rounded nearest whole number) Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

NOPAT (rounded nearest whole number)* Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

NOA (rounded nearest whole number)* Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

* Use sales rounded to nearest whole number for this calculation.


(d) Estimate the value of a share of Intel common stock using the discounted cash flow (DCF) model as of December 25, 2010; assume a discount rate (WACC) of 11%, common shares outstanding of 5,511 million, and net nonoperating obligations (NNO) of $(21,178) million (NNO is negative which means that Intel has net nonoperating investments).

  • Use your rounded answers for subsequent calculations.

  • Do not use negative signs with any of your answers below.

INTC Reported Forecast Horizon Terminal
($ millions) 2010 2011 Est. 2012 Est. 2013 Est. 2014 Est. Period
DCF Model
Increase in NOA Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

FCFF (NOPAT - Increase in NOA) Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Discount factor

(rounded to 5

decimal places)

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Present value of horizon FCFF

(rounded to nearest

whole number)

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Answer

Incorrect
Mark 0.00 out of 1.00

Cummu present value of horizon FCFF $Answer

Incorrect
Mark 0.00 out of 1.00

(rounded to nearest
whole number)
Present value of terminal FCFF Answer

Incorrect
Mark 0.00 out of 1.00

(rounded to nearest
whole number)
Total firm value Answer

Incorrect
Mark 0.00 out of 1.00

(rounded to nearest
whole number)
NNO Answer

Incorrect
Mark 0.00 out of 1.00

Firm equity value $Answer

Incorrect
Mark 0.00 out of 1.00

(rounded to nearest
whole number)
Shares outstanding (millions) Answer

Incorrect
Mark 0.00 out of 1.00

(rounded to nearest
whole number)
Stock price per share $Answer

Incorrect
Mark 0.00 out of 1.00

(rounded to two
decimal places)

In: Accounting

List the players that have either won more than 2 matches or lost more than 2...

  1. List the players that have either won more than 2 matches or lost more than 2 matches. List the player number, name, initials, won, and lost. Insert your snip here.
  1. Which players are captains of a team and have ever served as a committee members? Display the player number, player name, initials, team number, and committee member position. This will require 3 tables. Insert your snip here.
  1. Using a subquery, have any other players been penalized the same amount as player 8? Let MySQL do the work for you. Do not explicitly query for $25. Display the player number, player name, initials, and amount. Insert your snip here.
  1. Who has played more than 2 matches? Display the player number as ‘Number’, concatenate the player name (initials, space, name) as ‘Name’, and the number of matches played as ‘Number of Matches’. Insert your snip here.
  1. Sum the number of match wins and losses by player number. Display the player number as ‘Number’, concatenate the player name (initials, space, name) as ‘Name’, wins as ‘Total Wins’, and losses and ‘Total Losses’. Insert your snip here.

***********************************************************************************************************************************************

***********************************************************************************************************************************************

***********************************************************************************************************************************************

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players
(
playerno   int       not null    primary key,
name       varchar(15)   not null,
initials   varchar(3),
birth_date   date,
gender       char(1),
joined       int   not null,
street       varchar(15)   not null,
houseno       varchar(4),
zip       char(6),
town       varchar(10)   not null,
phoneno       char(10),
leagueno   char(4)
);

Insert into players values
(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),
(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),
(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),
(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),
(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),
(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),
(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),
(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),
(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),
(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),
(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),
(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),
(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),
(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members
(
playerno   int   not null,
begin_date   date   not null,
end_date   date,
position   varchar(20),
primary key(playerno, begin_date)
);

Insert into committee_members values
(2,'2010-01-01','2012-12-31','Chairman'),
(2,'2014-01-01',Null,'General Member'),
(6,'2010-01-01','2010-12-31','Secretary'),
(6,'2011-01-01','2012-12-31','General Member'),
(6,'2012-01-01','2013-12-31','Treasurer'),
(6,'2013-01-01',Null,'Chairman'),
(8,'2010-01-01','2010-12-31','Treasurer'),
(8,'2011-01-01','2011-12-31','Secretary'),
(8,'2013-01-01','2013-12-31','General Member'),
(8,'2014-01-01',Null,'General Member'),
(27,'2010-01-01','2010-12-31','General Member'),
(27,'2011-01-01','2011-12-31','Treasurer'),
(27,'2013-01-01','2013-12-31','Treasurer'),
(57,'2012-01-01','2012-12-31','Secretary'),
(94,'2014-01-01',Null,'Treasurer'),
(112,'2012-01-01','2012-12-31','General Member'),
(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches
(
matchno       int   not null   Primary Key,
teamno       int   not null   references teams(teamno),
playerno   int   not null   references players(playerno),
won       int,
lost       int
);


Insert into matches values
(1,1,6,3,1),
(2,1,6,2,3),
(3,1,6,3,0),
(4,1,44,3,2),
(5,1,83,0,3),
(6,1,2,1,3),
(7,1,57,3,0),
(8,1,8,0,3),
(9,2,27,3,2),
(10,2,104,3,2),
(11,2,112,2,3),
(12,2,112,1,3),
(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties
(
paymentno   int   not null   Primary Key,
playerno   int   not null   references players(playerno),
payment_Date   date   not null,
amount   decimal(10,2)   not null
);


Insert into Penalties values
(1,6,'2010-12-08',100.00),
(2,44,'2011-05-05',75.00),
(3,27,'2013-09-10',100.00),
(4,104,'2014-07-08',50.00),
(5,44,'2010-12-08',25.00),
(6,8,'2010-12-08' ,25.00),
(7,44,'2012-12-30',30.00),
(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams
(
teamno   int   Primary Key   Not Null,
playerno   int   Not Null   references players(playerno),
division   varchar(6)
);


Insert into teams values
(1,6,'first'),
(2,27,'second');

/* ********************************************************************************************
End of loading the database
******************************************************************************************** */

In: Computer Science

1.Which players have lost more matches than the average number of losses?   No duplicates should be...

1.Which players have lost more matches than the average number of losses?   No duplicates should be listed.   Order by player number.   Insert your screen shot here.

2.How many players from each town served on the committee in any capacity? Display the town as ‘Town’ and the number served as ‘Committee Service’.   Insert your screenshot here.

3.How many members come from each town? Display the town as ‘Town’ and the number of members as ‘Number’. Insert your screenshot here.

4.Who has served on the committee more than once? Display the player number as ‘Number’, concatenate the player initial and name as ‘Name’, town as ‘Town’, and number served as ‘Terms’. Insert your screenshot here.

Below I will include the tennis database

* *******************************************************************

CREATE and OPEN the TENNIS Base

******************************************************************* */

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players

(

playerno              int                         not null                primary key,

name                    varchar(15)         not null,

initials   varchar(3),

birth_date           date,

gender                 char(1),

joined                   int          not null,

street                   varchar(15)         not null,

houseno                             varchar(4),

zip                         char(6),

town                     varchar(10)         not null,

phoneno                             char(10),

leagueno             char(4)

);

Insert into players values

(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),

(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),

(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),

(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),

(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),

(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),

(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),

(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),

(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),

(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),

(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),

(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),

(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),

(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members

(

playerno              int          not null,

begin_date          date       not null,

end_date             date,

position               varchar(20),

primary key(playerno, begin_date)

);

Insert into committee_members values

(2,'2010-01-01','2012-12-31','Chairman'),

(2,'2014-01-01',Null,'General Member'),

(6,'2010-01-01','2010-12-31','Secretary'),

(6,'2011-01-01','2012-12-31','General Member'),

(6,'2012-01-01','2013-12-31','Treasurer'),

(6,'2013-01-01',Null,'Chairman'),

(8,'2010-01-01','2010-12-31','Treasurer'),

(8,'2011-01-01','2011-12-31','Secretary'),

(8,'2013-01-01','2013-12-31','General Member'),

(8,'2014-01-01',Null,'General Member'),

(27,'2010-01-01','2010-12-31','General Member'),

(27,'2011-01-01','2011-12-31','Treasurer'),

(27,'2013-01-01','2013-12-31','Treasurer'),

(57,'2012-01-01','2012-12-31','Secretary'),

(94,'2014-01-01',Null,'Treasurer'),

(112,'2012-01-01','2012-12-31','General Member'),

(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches

(

matchno                             int          not null Primary Key,

teamno                int          not null references teams(teamno),

playerno              int          not null references players(playerno),

won                      int,

lost                       int

);

Insert into matches values

(1,1,6,3,1),

(2,1,6,2,3),

(3,1,6,3,0),

(4,1,44,3,2),

(5,1,83,0,3),

(6,1,2,1,3),

(7,1,57,3,0),

(8,1,8,0,3),

(9,2,27,3,2),

(10,2,104,3,2),

(11,2,112,2,3),

(12,2,112,1,3),

(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties

(

paymentno         int          not null Primary Key,

playerno              int          not null references players(playerno),

payment_Date   date       not null,

amount decimal(10,2)     not null

);

Insert into Penalties values

(1,6,'2010-12-08',100.00),

(2,44,'2011-05-05',75.00),

(3,27,'2013-09-10',100.00),

(4,104,'2014-07-08',50.00),

(5,44,'2010-12-08',25.00),

(6,8,'2010-12-08' ,25.00),

(7,44,'2012-12-30',30.00),

(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams

(

teamno int          Primary Key        Not Null,

playerno              int          Not Null               references players(playerno),

division varchar(6)

);

Insert into teams values

(1,6,'first'),

(2,27,'second');

/* ********************************************************************************************

End of loading the database

******************************************************************************************** */

In: Computer Science