Questions
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

Does a mother who is found guilty of using drugs during the conception of a child...

Does a mother who is found guilty of using drugs during the conception of a child deserve the opportunity to earn back her parental rights?

In: Psychology

How did the colonists mobilize for war? Discuss specific challenges they faced and any unintended consequences...

How did the colonists mobilize for war? Discuss specific challenges they faced and any unintended consequences of their solutions.

In: Psychology

There are 5000 CFM of outdoor air with a temp of 40F 35Fwb heated and humidified...

There are 5000 CFM of outdoor air with a temp of 40F 35Fwb heated and humidified under steady-flow conditions to a final temp of 70F and 40%RH a)find the mass of water vapor added to each pound mass of dry air b) if the water is supplied at 50F how much heat in Btu/min.

In: Mechanical Engineering

1) How does capital investment affect the marginal physical product of labor? Does more college education...

1) How does capital investment affect the marginal physical product of labor? Does more college education have the same kind of effect? Which is a better investment? Please explain your answers in detail.

(2) While explaining your answer in detail, if you wish, you can also include an example. According to the rule for optimal input usage, a firm should hire a person as long as her marginal revenue product is greater than her marginal cost to the company. It is well known that many companies have management training programs in which new trainees are paid relatively high starting salaries and are not expected to make substantial contributions to the company until after the program is over (programs may run between 6 to 18 months). In offering such training programs, is a company violating the optimality rule? Explain.

In: Operations Management

Growth​ Company's current share price is $ 20.10 and it is expected to pay a $...

Growth​ Company's current share price is $ 20.10 and it is expected to pay a $ 0.95 dividend per share next year. After​ that, the​ firm's dividends are expected to grow at a rate of 4.4 % per year. a. What is an estimate of Growth​ Company's cost of​ equity? b. Growth Company also has preferred stock outstanding that pays a $ 2.25 per share fixed dividend. If this stock is currently priced at $ 28.15​, what is Growth​ Company's cost of preferred​ stock? c. Growth Company has existing debt issued three years ago with a coupon rate of 6.1 %. The firm just issued new debt at par with a coupon rate of 6.4 %. What is Growth​ Company's cost of​ debt? d. Growth Company has 5.3 million common shares outstanding and 1.4 million preferred shares​ outstanding, and its equity has a total book value of $ 49.9 million. Its liabilities have a market value of $ 19.5 million. If Growth​ Company's common and preferred shares are priced as in parts ​(a​) and ​(b​), what is the market value of Growth​ Company's assets? e. Growth Company faces a 38 % tax rate. Given the information in parts ​(a​) through ​(d​), and your answers to those​ problems, what is Growth​ Company's WACC? ​Note: Assume that the firm will always be able to utilize its full interest tax shield.

In: Finance

GSU president is trying to analyze crime rates so they can shift their patrols from decreasing-rate...

GSU president is trying to analyze crime rates so they can shift their patrols from decreasing-rate areas to areas where rates are increasing. The city and county have been geographically segmented into areas containing 5,100 residences. The police recognize that not all crimes and offenses are reported: people do not want to become involved, consider the offenses too small to report, are too embarrassed to make a police report, or do not take the time, among other reasons. Every month, because of this, the police are contacting by phone a random sample of 1,020 of the 5,100 residences for data on crime. (Respondents are namelessness.) Here are the data collected for the past 12 months for one area:

MONTH          CRIME                        SAMPLE         CRIME

                    INCIDENCE          SIZE             RATE

January           9                      1,020            0

February         11                     1,020             0

March               9                       1,020            0

April                  9                        1,020            0

May                  9                        1,020            0

June                11                       1,020            0

July                 10                       1,020            0

August             12                       1,020            0

September      10                       1,020            0

October           13                       1,020            0

November       11                       1,020            0

December       10                       1,020            0

a. Determine the P−, Sp, UCL and LCL for a p-chart of 95 percent confidence (at Z = 1.96). (Round your answers to 5 decimal places.)

P−     

Sp       

UCL    

LCL    

b. If the next three months show crime incidences in this area as

January = 10 (out of 1,020 sampled)

February = 12 (out of 1,020 sampled)

March = 11 (out of 1,020 sampled)

What comments can you make regarding the crime rate?

            The process is in control.

            The process is out of control

In: Operations Management

A 13.35-year maturity zero-coupon bond selling at a yield to maturity of 8% (effective annual yield)...

A 13.35-year maturity zero-coupon bond selling at a yield to maturity of 8% (effective annual yield) has convexity of 164.2 and modified duration of 12.36 years. A 40-year maturity 6% coupon bond making annual coupon payments also selling at a yield to maturity of 8% has nearly identical modified duration—-12.30 years—-but considerably higher convexity of 272.9.

a. Suppose the yield to maturity on both bonds increases to 9%. What will be the actual percentage capital loss on each bond? What percentage capital loss would be predicted by the duration-with-convexity rule? (Do not round intermediate calculations. Round your answers to 2 decimal places.)

Zero-Coupon Bond Coupon Bond
Actual loss % %
Predicted loss % %

b. Suppose the yield to maturity on both bonds decreases to 7%. What will be the actual percentage capital gain on each bond? What percentage capital gain would be predicted by the duration-with-convexity rule? (Do not round intermediate calculations. Round your answers to 2 decimal places.)

Zero-Coupon Bond Coupon Bond
Actual gain % %
Predicted gain % %

In: Finance

1. Solve the equations 256? ≡ 442(??? 60), 3? + 4 ≡ 6(??? 13). 5. Prove...

1. Solve the equations 256? ≡ 442(??? 60), 3? + 4 ≡ 6(??? 13).

5. Prove that ?2 + ? + 1 is an irreducible polynomial of degree 2.

In: Advanced Math

What was the significance of the Battle of Stone's River?

What was the significance of the Battle of Stone's River?

In: Psychology

When an opinion poll calls landline telephone numbers at random, approximately 30% of the numbers are...

When an opinion poll calls landline telephone numbers at random, approximately 30% of the numbers are working residential phone numbers. The remainder are either non-residential, non-working, or computer/fax numbers. You watch the random dialing machine make 20 calls. (Round your answers to four decimal places.)

(a) What is the probability that exactly 4 calls reach working residential numbers?


(b) What is the probability that at most 4 calls reach working residential numbers?


(c) What is the probability that at least 4 calls reach working residential numbers?


(d) What is the probability that fewer than 4 calls reach working residential numbers?


(e) What is the probability that more than 4 calls reach working residential numbers?

In: Math

Project L requires an initial outlay at t = 0 of $83,559, its expected cash inflows...

Project L requires an initial outlay at t = 0 of $83,559, its expected cash inflows are $14,000 per year for 9 years, and its WACC is 11%. What is the project's IRR? Round your answer to two decimal places.

%


Project L requires an initial outlay at t = 0 of $59,000, its expected cash inflows are $15,000 per year for 6 years, and its WACC is 12%. What is the project's payback? Round your answer to two decimal places.

years

In: Finance

Activity- ELECTRICAL SAFETY ACCIDENT As a Manager you have responsibility for a large kitchen. This contains...

Activity- ELECTRICAL SAFETY ACCIDENT
As a Manager you have responsibility for a large kitchen.
This contains a water softener unit through which water has to pass before being delivered to a dishwasher. The water softener unit had been causing problems recently so you agree with the kitchen manager to call in the maintenance contractor to look at the equipment. The equipment, which consists of a tall cylinder is located underneath a sink draining tray in the corner of the kitchen.
After carrying out some remedial work the contractor decides to test out the functioning of the equipment. The equipment is fitted with a time clock which means that the operating cycle can be set by kitchen staff. To check that the unit is coming on and off according to the timed settings the contractor removes a cover from the unit.
The cover is posted with an electrical hazard warning sign. Removal of the cover gave the contractor access to a cam, the rotation of which operates, or switches off, the equipment according to the time settings. This is a quick way of working through the time cycle.
The electrical hazard warning sign relates to the hazard arising from two electrical terminals which depending on the position of the cam are either electrically live i.e. when equipment is switched on, or dead i.e. when equipment is switched off. During this simulation of the unit’s operating cycle the contractor was sat on the tiled floor underneath the sink draining board with his legs extending beyond the sink into the kitchen.
While doing this a member of the kitchen staff went into this area and saw the contractor was ‘shaking’. At first she was slightly embarrassed as she thought the contractor was ‘having a fit’ and did not immediately mention it to her supervisor. When she did, they went to see the contractor and, getting no response from him, switched the equipment off at the mains before removing him from underneath the sink. An ambulance was then called and the contractor taken to hospital where he was detained overnight, then discharged. The contractor had sustained an electric shock rather than a ‘fit’.
As Manager of this area, using the facts provided and any reasonable assumptions you wish to make,
* outline the (causative) factors leading to this accident with reference to failures
in safe plant & equipment; competent staff; safety culture; and safe systems
of work / safe procedures
* identify
* what are the responsibilities of your organisation for the contractor
* what health and safety information should have been obtained from the contractor
* what, if any, action should be taken against the contractor
* recommendations on what should be done to avoid a recurrence
* also identify possible breaches of statutory legislation and comment on how significant / serious these are
*should be between 500-750 words and must include your name, registration number, word count and set out the brief. Where appropriate, referencing should be provided.

In: Electrical Engineering

for eclipse java Overview Write a program that translates an English phrase into a Pig Latin...

for eclipse java

Overview
Write a program that translates an English phrase into a Pig Latin phrase. Input a phrase from the user and translate it to pig latin. You can assume the phrase will be on a single line.

Use at least the REQUIRED METHODS listed below, with the exact same SPELLING for method names and parameters.

Input Specification
The input will be an English phrase, with NO terminal punctuation. Read the phrase as a SINGLE STRING using the nextLine method.

Use PRECISELY the format below with the EXACT same SPACING and SPELLING.

Please enter a phrase ==> <user input>
Output Specification
Output an introductory message, a prompt for the English word, and a translation for the inputted word.

Use PRECISELY the format below with the EXACT same SPACING and SPELLING. The output below assumes the user entered "Humpty Dumpty sat on the wall".

This program will convert an English phrase into Pig Latin.

Please enter a phrase ==> Humpty Dumpty sat on the wall

"Humpty Dumpty sat on the wall"
in Pig Latin is
"umpty-Hay umpty-Day at-say on-way e-thay all-way"

************************
Required Methods

// Prompt and read a phrase to translate
public static String readPhrase (Scanner console)

// Convert a phrase to Pig Latin and return it
public static String convertPhrase (String englishPhrase)

// Convert a word to Pig Latin and return it
public static String convertWord (String englishWord)

// Return true if "c" is a vowel, false otherwise.
// Handle both lowercase and uppercase letters.
public static boolean isVowel (char c)

// Print result of translation
public static void printResult (String englishPhrase, String pigLatinPhrase)
Hints
You already wrote a method to convert a single word (convertWord). Apply it to each word in the phrase, forming the translated phrase by concatenating the translated words. If you did not get convertWord working on the first lab assignment, you need to get it working now.

Class Scanner can process a String (instead of System.in) consisting of multiple words, and break it into words that are separated by whitespace (tabs, spaces, and newline characters). You know other ways to break a line into words, so you do NOT have to use this technique.

Correctly handle whitespace before and after words.

In: Computer Science

Q5:      Which type of RAM is used exclusively in laptops? SODIMM DDR3 DDR DDR4 Q6:      Which...

Q5:      Which type of RAM is used exclusively in laptops?

  • SODIMM
  • DDR3
  • DDR
  • DDR4

Q6:      Which firmware security standard can be used to store disk encryption keys?

  • SLA
  • TPM
  • UEFI
  • USB

Q7:      Which RAID level is Disk Mirroring?

  • 3
  • 1
  • 0
  • 5

Q8:      Which type of printer uses toner?

  • Impact
  • Inkjet
  • Thermal
  • Laser

Q9:      Which technique do 3D printers use to create objects?

  • Fusing
  • Heating
  • Layering
  • Carving

Q10:    Which of the following item DOES NOT store data?

  • Random Access Memory
  • CD-R
  • LCD Screen
  • USB Drive

In: Computer Science