![Database Answers](../../images/dba_400_home.jpg) |
|
|
![](../../images/spacer.gif) |
Back to the Data Model
The Specifications have been defined by Peter as follows :-
I am attempting to create a website that will allow tracking of stats for a pool league.
I know what information I wish to store.
I just seem unable to structure a database.
Firstly some important information about the structure/rules of the League.
Pool League contains x_amount of Divisions (normally 4 or 5)
Divisions contains y_amount of Teams (normally around 10)
Teams contains z_amount of Players (6+)
Each player can only play for 1 team.
Summer League Matches consist of 9 singles games
Winter League Matches consist of 6 singles games and 3 doubles games
A team recieves 1 point for each frame that is won, plus 2 for winning.
I wish to track..
Team Stats
----------
leagueStanding
gamesPlayed
homeWins
homeLosses
homeFrameWins
homeFrameLosses
awayWins
awayLosses
awayFrameWins
awayFrameLosses
totalFrameWins
totalFrameLosses
Player Stats
----------
gamesPlayed
gamesWon
percentageWon
Fixtures
Results
From these Specifications, we can see that the Things of Interest are :-
- Games
- Leagues
- Teamss
- Others to be determined
How are these Things related ? :-
- A Game involves two Teams.
- A Team can belong to only one League at a time.
Barry Williams
Principal Consultant
May 22nd. 2009
Database Answers Ltd.
London, England
|
|
![](../../images/v3/spacer.gif) |
![](../../images/v3/spacer.gif) |
|