Reference no: EM131971763
The following tables form part of a database held in a relational database management system for a football club, which has many teams in different leagues. The aim of the database is to record its teams' progress in a competition. The database consists 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 team and plays for only one team. Player's contract is not 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 30 years old and who live in Manchester. The names should be displayed in alphabetical order.
(c) The number of wins of each team for each division
(d) A procedure "getTotalAmountPaid" which calculates the total amount paid to a player. The procedure takes as input the payment number and displays the player number, player name and total amount paid. For example, assume that the total amount paid for player No10 is £1000000, the procedure should display the following:
"Total Amount paid for Player 10 is £1000000"
(e) A table-valued function "getPlayer" that returns the player number,player name, team number, division, date contract began,date it ended and position of the player. The function takes as input the player number.
What monthly operating income for a sales volume of keyboard
: Rockwell Corporation manufacture and sells computer keyboards. The flexible budget reflect what monthly operating income for a sales volume of 52,000 keyboards?
|
Describe the topography on either side of the plate boundary
: Describe the topography on either side of the plate boundary (height and depth) and explain how the topography is linked to the geologic processes
|
Compute the eac for both machines
: You are evaluating two different silicon wafer milling machines. The Techron I costs $219,000, has a three-year life, and has pretax operating costs of $56,000.
|
What questions should be asked regarding the computer system
: What can be done to restore these deleted files and what questions should be asked regarding the computer system?
|
Relational database management system for a football club
: The following tables form part of a database held in a relational database management system for a football club, which has many teams in different leagues.
|
Prepare the journal entry to record the sale of smartphone
: Prepare the journal entry to record the sale of smartphone in 2017 by R&R Cellular. Note that the firm uses perpetual inventory method.
|
What is evanec cost of retained earnings
: What is Evanec's cost of retained earnings, rs? Round your answer to two decimal places. Do not round your intermediate calculations.
|
Use sql statement to construct the queries
: For each crew, if the crew is allergic to no flowers that grow on his/her hometown, then list the crew's name.
|
Prepare the adjusting entries on january
: Prepare the adjusting entries on January 31. Account titles are Accumulated Depreciation-Equipment, Depreciation Expense, Service Revenue, Accounts Receivable.
|