Addendum 3 - New table requirements

New table(s) are required to store rating and title information. This is just a basic description of the data that needs to be stored. The programmer should make any decisions on how to store and retrieve the data based on optimum database design.

ID # ( link to other tables as necessary)

The following fields need to be kept for both the regular and quick rating system.

Current rating

Previous rating

Last published rating

Floor

N ( number of games played)

Title counters ( as defined by the title system document.) Important note! The counter for 2200 currently exists and must be imported from the current system.

For the postal rating system

Current rating

Peak rating

# games

Quit (y/n)

Date last rated

The current postal rating system is implemented in cobol and needs to be modified to update and read this data.

The most important part of the system is to be able to access the UA system for membership information.

The current system keeps about 20 additional accumulator fields to keep track of various items both by year and total. I do not know if this should be maintained or a query should be run either when the data is needed or on a periodic basis to update the fields. This has been a maintenance nightmare to maintain when the wrong player is reported as having played in a tournament and then a correction has been made. The accumulator fields for the titles will have the same problem.