Athletics Database System With Calculating Ranking

• Olympic Games and Commonwealth Games are both of the major sports events in the world.
• For example, Athletics is one of the category of events in the Olympic Games.
• Do you know how the management of this major sports event calculated  the record for each of the athlete?   

Shingo Suetsugu (JPN)
M 100m-200m 2000s-

Merlene Ottey (JAM)
F 100m-200m 1980s-1990s

Pietro Mennea (ITA)
M 100m-200m 1970s-1980s

• This entry provides you with an innovational ranking extraction system in athletics running events.You can get any rankings interactively in various conditions you set in. 
• BASIC RULES
• When calculating the Competition Score the following factors are considered:

• 1. Result Score: The actual results achieved in the competition
  2. Participation Score: The level of the participating athletes
  3. WR Bonus: World Records achieved in the competition
  Competition Score = Competition Result Score + Competition Participation Score + WR Bonus

  1. Competition Result Score

  
  

  1.1. Calculating the Competition Result Score

  1. The 24 best Events (see 1.2.) plus the 24 best remaining results (see 1.3.), i.e. a total of 144 results, are calculated to get the Result Score of the competition.

  1.2. Calculating the 24 best Events:

  1. The 5 best results in all the Events are added up to get the Event's Result Score.
  2. From all the Events which meet the above requirement, the 24 best Events are included for the calculation
  3. In the 24 best Events only Finals are considered. Heats, Quarterfinals, Semifinals, Qualifications or individual events during the combined events are not included in this calculation.

  1.3. Remaining 24 results

  1. From all the results which are not included in the 5 best results of the 24 best Events, the remaining 24 best results are included.
  2. Results from Heats, Quarterfinals, Semifinals, Qualifications and individual events during the combined events are also considered when calculating the remaining 24 results.

  1.4. Result Scores

  1. Results Scores are awarded for the result achieved by the athlete according to the latest edition of the relevant (i.e. indoor/outdoor) IAAF Scoring Tables of Athletics (by Dr. Bojidar Spiriev). For disciplines which are not included in the latest editions of IAAF Scoring Tables of Athletics, special Scoring Tables have been developed in full conformity with the IAAF versions.
  2. In Track & Field events Results Scores are calculated with the Wind and Hand Timing Modification System, as used in the All-Athletics.com World Rankings as well.
  3. In Road Running events Results Scores are calculated with the Downhill and Point-to-Point course Modification System, as used in the All-Athletics.com World Rankings as well.

As conclusion, all the management of the sports event will use specific database system to makes the program running smoothly and avoid mistaken and failure to the competition results. It is to make sure all the party satisfies with the results and to avoid cheating among the athlete.As far as my understandings, all the results score will update from year to year to crate a new world records based on the athlete achievements. All this output system will be produced by the database system who gathered all the input data.Tq~

Credit to:  1)Hiroshi Yokouchi,2)www.all-athletics.com

Sources Retrieved From; 

http://www.yoko20934.net/public/RunDB/index_E.htm

http://www.topendsports.com/events/index.htm

http://www.all-athletics.com/en-us/rules-all-athletics-world-rankings-2010-track-field-events#modres