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 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 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 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 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 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 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 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 |
$Answer
Incorrect |
$Answer
Incorrect |
$Answer
Incorrect |
$Answer
Incorrect |
$Answer
Incorrect |
| Sales (rounded nearest whole number) | Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
| NOPAT (rounded nearest whole number)* | Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
| NOA (rounded nearest whole number)* | Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
* 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 |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
|
| FCFF (NOPAT - Increase in NOA) | Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
|
| Discount factor |
(rounded to 5 decimal places) |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
|
| Present value of horizon FCFF |
(rounded to nearest whole number) |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
Answer
Incorrect |
|
| Cummu present value of horizon FCFF | $Answer
Incorrect |
(rounded to nearest whole number) |
||||
| Present value of terminal FCFF | Answer
Incorrect |
(rounded to nearest whole number) |
||||
| Total firm value | Answer
Incorrect |
(rounded to nearest whole number) |
||||
| NNO | Answer
Incorrect |
|||||
| Firm equity value | $Answer
Incorrect |
(rounded to nearest whole number) |
||||
| Shares outstanding (millions) | Answer
Incorrect |
(rounded to nearest whole number) |
||||
| Stock price per share | $Answer
Incorrect |
(rounded to two decimal places) |
||||
In: Accounting
***********************************************************************************************************************************************
***********************************************************************************************************************************************
***********************************************************************************************************************************************
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 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