Q2.7. Has any male player played in the Mens, Senior Mens, and Mixed teams for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q2.7. Has any male player played in the Mens, Senior Mens, and Mixed teams for the same club? List the full name of the player and the club. "Touch" rugby is a five-person game that is played in the off season (usually late Spring to late early Autumn). It is a fast and lively game where instead of tackling other players to the ground – they only have to touch or 'tag' the player for there to be a restart in play. There are 8 touch rugby clubs that compete in the Melbourne Touch Rugby Summer comptition. There are currently four competitions: mens, womens, seniors – for men over the age of 35 years, and a mixed division for teams made up of men and women. A mixed team must have a minimum of three female players in every game. A team must have a minimum of four players available to play the game. If one team is unable to field a side (minimum of four players) at the game start time they forfeit the game and suffer a walkover, and do not record any value for their score. The other team scores 28 points. The competitions have been running for several seasons, with the details of every game and participating teams and players carefully recorded. competition I season game CompetitionID INT yearly 9 SeasonID INT GamelD INT O CompetitionName VARCHAR(18) H- KO SeasonYear YEAR E- made up of O Round SMALLINT CompetitionType VARCHAR(10) CompetitionID INT • Sea sonID INT Inde xes Indexes • Team1 SMALLINT Team2 SMALLINT O Team1Score TINYINT O Team2Score TINYINT plays in a GameDate DATE O StartTime TIME O player O playerteam PlayerID INT P GamelD INT Indexes O FirstName VARCHAR... 1 TeamID SMALLINT O LastName VARCHAR... selected for 1 PlayerID INT O Sex ENUM('M', F) team 1 competes Indexes Indexes team 2 competes member of represents O club I team O clubplayer ClubID INT TeamID SMALLINT * ClubID INT O ClubName VARCHAR(35) O TeamName VARCHAR(25) belongs to hosts 1 PlayerID INT O FromDate DATE Address1 VARCHAR(25) TeamType ENUM(...) O Address2 VARCHAR(25) • ClubID INT O TODate DATE O Suburb VARCHAR(15) Indexes Indexes O Postcode CHAR(4) Inde xes Figure 1 Touch Rugby Physical E.R. Model Q2.7. Has any male player played in the Mens, Senior Mens, and Mixed teams for the same club? List the full name of the player and the club. "Touch" rugby is a five-person game that is played in the off season (usually late Spring to late early Autumn). It is a fast and lively game where instead of tackling other players to the ground – they only have to touch or 'tag' the player for there to be a restart in play. There are 8 touch rugby clubs that compete in the Melbourne Touch Rugby Summer comptition. There are currently four competitions: mens, womens, seniors – for men over the age of 35 years, and a mixed division for teams made up of men and women. A mixed team must have a minimum of three female players in every game. A team must have a minimum of four players available to play the game. If one team is unable to field a side (minimum of four players) at the game start time they forfeit the game and suffer a walkover, and do not record any value for their score. The other team scores 28 points. The competitions have been running for several seasons, with the details of every game and participating teams and players carefully recorded. competition I season game CompetitionID INT yearly 9 SeasonID INT GamelD INT O CompetitionName VARCHAR(18) H- KO SeasonYear YEAR E- made up of O Round SMALLINT CompetitionType VARCHAR(10) CompetitionID INT • Sea sonID INT Inde xes Indexes • Team1 SMALLINT Team2 SMALLINT O Team1Score TINYINT O Team2Score TINYINT plays in a GameDate DATE O StartTime TIME O player O playerteam PlayerID INT P GamelD INT Indexes O FirstName VARCHAR... 1 TeamID SMALLINT O LastName VARCHAR... selected for 1 PlayerID INT O Sex ENUM('M', F) team 1 competes Indexes Indexes team 2 competes member of represents O club I team O clubplayer ClubID INT TeamID SMALLINT * ClubID INT O ClubName VARCHAR(35) O TeamName VARCHAR(25) belongs to hosts 1 PlayerID INT O FromDate DATE Address1 VARCHAR(25) TeamType ENUM(...) O Address2 VARCHAR(25) • ClubID INT O TODate DATE O Suburb VARCHAR(15) Indexes Indexes O Postcode CHAR(4) Inde xes Figure 1 Touch Rugby Physical E.R. Model
Expert Answer:
Answer rating: 100% (QA)
Answer SELECT concatPFirstNamePLastName as FullName CClubName ... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these accounting questions
-
A local golf club has mens and womens summer leagues. The following data give the scores for a round of 18 holes of golf for 17 men and 15 women randomly selected from their respective leagues. a....
-
Are men or women more adept at remembering where they leave misplaced items (such as car keys)? According to University of Florida psychology professor Robin West, women show greater competence in...
-
Spring and Summer compete in the same market. The following budgeted income statements illustrate their cost structures: Required a. Assume that Spring can lure all 100 customers away from Summer by...
-
. The electric polarization P of a light wave for high values of the electric field E is given by: P= a(c,E+cE + cE) where a, c1, c2 and c3 are constants. Find the expression for the instantaneous...
-
Assume materiality for the financial statements as a whole is $100,000 and performance materiality for accounts receivable is set at $40,000. If the auditor finds one receivable that is overstated by...
-
The file 14includes the total compensation (in $millions) for CEOs of 194 large public companies and the investment return in 2011. (Data extracted from...
-
Presented below are profitability ratios for three competitors: Bristol-Myers Squibb (BMY), Pfizer, Inc. (PFE), and Johnson & Johnson (JNJ): Required Compare the relative profitability of the three...
-
Dave Fletcher, the general manager of North Carolina Engineering Corporation ( NCEC), thinks that his firms engineering services contracted to highway construction firms are directly related to the...
-
The forecasted sales pertain to Yang, Inc.: Month Sales January $1,000,000 February 1,250,000 March 750,000 April 500,000 Collection pattern: 70 percent in month of sale; 30 percent in month...
-
The graph in Figure 1.38 shows the distance versus time for an elevator as it moves up and down in a building. Compute the elevators velocity at the times marked a, b, and c. 32 28 24 20 16 12 a 28...
-
5.6-2 Refractive Index of Air. The refractive index of air can be precisely measured with the help of a Michelson interferometer and a tunable light source. At atmospheric pressure and a temperature...
-
Define the term Balanced Scorecard. Explain how the Balanced Scorecard is important to the Control function.
-
How do advances in molecular genetics, particularly CRISPR-Cas9 gene editing technology, revolutionize our ability to manipulate and engineer genomes for various applications, including biomedicine,...
-
Explore the concept of emergent properties in biological systems, elucidating how interactions among biomolecules at different organizational levels give rise to novel functionalities and behaviors...
-
An equally weighted index has three stocks A, B, and C at $20, $10, and %100 yesterday, respectively. Yesterday, stock C has a split where one share split into 2 and the price was reduced from $100...
-
Calculate financial ratios for East Coast and compare them to their industry. What conclusions do you draw? Do a proforma for the next year, . Assume Sales grow at 20%. The firm stays as efficient...
-
Assume that when human resource managers are randomly selected, 41% say job applicants should follow up within two weeks. If 8 human resource managers are randomly selected, find the probability that...
-
Identify the most stable compound:
-
How are multi-valued dependencies incorporated into the definition of fourth normal form (4NF)?
-
Consider the following relation instance of the CAR relation schema: a. What is the minimal cover of functional dependencies that exists in CAR? b. What is (are) the candidate key(s) of CAR? c. If...
-
Consider the following Presentation Layer ER diagram. a. Identify all entity types that at one time or another function as a superclass. b. List the superclass entity type and subclass entity type(s)...
-
In what ways can management empower employees? What are the advantages of empowering employees?
-
Application of data analytics Indicate which type of data analytics, 1 through 4, is described in each of the following statements describing a data analytics application, \(a\) through \(h\). Data...
-
Access the Institute of Management Accountant's report titled "The Data Analytics Implementation Journey in Business and Finance," (https://www.imanet.org/...
Study smarter with the SolutionInn App