MYSQL

| December 15, 2015
  • CreateTournament(TournamentName, NumberOfTeams, StartDate, TicketPrice).

 

 

 

This procedure populates the tournament table with the ids of teams playing in a tournament.   Each tournament is given a name (e.g. ‘Kingston Cup’).   The procedure selects the teams with the highest point score to play in the tournament. (The number of teams selected to play is given by the NumberOfTeams parameter).   The qualifying teams are paired up so that the team with the highest point score plays the team with the lowest point score. (E.g. if there are six teams in the tournament, #1 plays #6, #2 plays #5, and #3 plays #4.)

 

 

 

The procedure schedules one game per day.   The first pair of teams play on the specified start date. The next pair plays the following day, etc.   E.g. if the start date is Nov 1, and there are six teams in the tournament, game 1 is played on Nov 1, game 2 on Nov 2, and game 3 on Nov 3.

 

 

 

This procedure also sets the base ticket price for all games in the tournament.

Get a 5 % discount on an order above $ 150
Use the following coupon code :
2018DISC
Tortoise and the Hare
Ray Tracing

Category: sample papers

Our Services:
Order a customized paper today!