Please Help Sql Server Question Following Tables Form Part Database Held Relational Databa Q43808133
Please help on below SQL Server question :
The following tables form part of a database held in arelational database management system for a football club, whichhas many teams in different leagues. The aim of the database is torecord its teams’ progress in a competition. The databaseconsists of the following tables :
PLAYER (PlayerNo, Name, Birth_Date, Age,Street_Address, Town,Phone, TeamNo).
TEAM (TeamNo,Division)
MATCH (MatchNo, TeamNo, PlayerNo)
RESULT(MatchNo, Win_TeamNo).
PAYMENT (PaymentNo, PlayerNo, Payment_Date, Amount).
CONTRACT (PlayerNo, Begin_Date, End_Date, Position).
Assumption: A player has only one contract with the teamand plays for only one team. Player’s contract isnot renewed once ended.
Using SQL and TransSQL, formulate the following:
(a) The maximum and minimum payment amount of players.
(b) Get the player number and name of players who are less than 30years old and
who live in Manchester. The names should be displayed inalphabetical order.
(c) The number of wins of each team for each division
(d) A procedure “getTotalAmountPaid” which calculates the totalamount paid to a
player. The procedure takes as input the payment number anddisplays the player
number, player name and total amount paid. For example, assume thatthe total
amount paid for player No10 is £1000000, the procedure shoulddisplay the
following:
“Total Amount paid for Player 10 is £1000000”
Many thanks !!!
Expert Answer
Answer to Please help on below SQL Server question : The following tables form part of a database held in a relational database ma…
OR