Hi there..I have been given the daunting task of taking years of tournament scores and develop a database to calculate the bowlers tournament average. Each bowling season bowlers bowl in 3 mandatory tournaments and one optional. Each tournaments' scores and number of games (usually 6 or 10) are kept to calculate totals for that current season. Then they are purged at the end of the season. However, they are kept (archived) to calculate the bowlers true average of every game bowled. I think I need a tournaments, bowlers, scores table. But being a newbie at databases, I am not sure how to join them and how to keep the scores in the archive which I will populate with past data.
Any help would be appreciated.
P.s the current years results are rather tricky, but we will get into that later.