League database
Posted by: roger.in.eugene
Date: May 20, 2007 12:03PM

I'm doing a major overhaul of a database for league results. the old system just kept track of peoples records for a week.
The new one, I want to keep track of the individual games. It should give me the ability to track stats against the opponents and stuff.

Essentially, there are 17 games in a match.
8 games are singles, two different types of games.
8 games are doubles. two different types of games also.
1 game is a team game.
A team is at least 4 people.
People will have different partners in the doubles games from week to week.
I'm thinking the best approach would be to have a table for each type of game, then each record would list the player, the team-mate, and the opposing players.
Does this pretty much sound like the way I should be going with it?
In theory, a 'doubles' game would generate 4 records, 1 for each of the players. Or should I just use a single record to reflect a 'game'?

Thanks for any pointers.

Roger

Options: ReplyQuote


Subject
Written By
Posted
League database
May 20, 2007 12:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.