The foundation of any ranking system is its link to the registration system of players.  All past and present players and any teams they’ve played on are linked here.  The ranks go with the players and the teams they played on.  The coaches table is filled when registering a player and indicating the parent or guarding is coaching.  A link is made between the two, so future coaching opportunities all fall under the same coach.

I listed four screens I use to manage player and coaches data:

  1. Coach Search
  2. Coach Registration
  3. Player Search
  4. Player Registration

The system will also give you different options if the user is a read-only or a read-write type of user.  Adding and updating of records should be left to only a few select individuals.  As with any other data processing system, Garbage-In, Garbage-Out.  I leave the actual entry of records with our registration person (my wife and I) and then give all of the commissioners in the league read-only access so they can look-up any player records they may need.  It cuts down the phone calls to the registration staff when a phone number doesn’t work.  Commissioner’s are looking at everything we have on file.