Database Answers Pool League Statistics

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Pool League Statistics
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
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map