I am needing to develop a small application to allow my local tennis club to keep track of its members mini singles leagues during the season.
For each category of player (Male/Female and Junior/Senior) There are a number of mini-leagues. During any month, a player may challenge any other player in their league to a singles match over 3 sets.
Players receive 2 points for a win. There are no draws. At the end of each month, the top 2 players of each mini-league (apart from the top league, obviously) are promoted and the bottom 2 players of all but the bottom league are demoted.
I need to be able to display, insert, update and delete rows from each of the tables appropriately. I need to record all the match results, and a means of automating the promotion/demotion end of month run.
In additon to this i need to have the following reports generated.
• List of players
• List of players in a given league
• In name order
• In place order
• List of match results for a given league
• List of match results for a given player