Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

3.30 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

Answer SELECT concatPFirstNamePLastName as FullName CClubName ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Modeling and Database Design

Authors: Narayan S. Umanath, Richard W. Scammel

2nd edition

1285085256, 978-1285085258

More Books

Students also viewed these Accounting questions

Question

Identify the most stable compound:

Answered: 1 week ago