Database Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesDatabase Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 27th, 2006, 01:54 PM
Harlequeen Harlequeen is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2005
Posts: 12 Harlequeen User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 36 m
Reputation Power: 0
League database

I am trying to work out how to structure a database for a league table for a darts league. There are 4 divisions and each team plays 15 other teams on a home and away basis. The winning team is awarded points for each individual game they play, plus 1 extra point if they win the match.

I am struggling to think how to structure this so that I can produce a fixture list and record scores and output a league table on a weekly basis.

If anyone can help I would appreciate it.

This may be beyond me as I am a learner, but I thought I should try to develop something useful for myself, at least.

Thanks

Harlequeen

Reply With Quote
  #2  
Old May 16th, 2008, 02:45 PM
Dhallagin Dhallagin is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2008
Posts: 1 Dhallagin User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 m 45 sec
Reputation Power: 0
same issue

I am working on the same type of setup, fewer teams smaller, but am building it for the future I hope. Used to use dartman to manage it, but it is cost prohibitive right now so am going to put together an idiot proof (meaning myself) data base using access, but it has been a while since I have done much creating with access.

Quote:
Originally Posted by Harlequeen
I am trying to work out how to structure a database for a league table for a darts league. There are 4 divisions and each team plays 15 other teams on a home and away basis. The winning team is awarded points for each individual game they play, plus 1 extra point if they win the match.

I am struggling to think how to structure this so that I can produce a fixture list and record scores and output a league table on a weekly basis.

If anyone can help I would appreciate it.

This may be beyond me as I am a learner, but I thought I should try to develop something useful for myself, at least.

Thanks

Harlequeen

Reply With Quote
  #3  
Old May 16th, 2008, 05:16 PM
dykebert's Avatar
dykebert dykebert is offline
Contributing User
Click here for more information
 
Join Date: Apr 2008
Posts: 429 dykebert User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 Days 30 m 5 sec
Reputation Power: 10
Well the basics are pretty simple:

tblTeam
teamID - Primary key
teamName
teamManagerName
teamManagerEMail
teamManagerPhone
teamPoints

tblDivision
divisionID - Primary key
divisionName

tblDivisionTeam
div_teamID - Primary key
divisionID - Foreign key to tblDivison
teamID - Foreign key to tblTeam

tblMatches
matchID - Primary key
matchDate
homeTeamID - Foreign key to tblTeam
awayTeamID - Foreign key to tblTeam
*homeTeamPoints
*awayTeamPoints

* You may or may not want these fields based depending on how you want to keep track of the points.

Do you need to keep track of the outcome of the individual games in the DB? If so do you need to keep track of the scores or just who won?

Do you need to keep track of the players for each team?

Reply With Quote
  #4  
Old April 22nd, 2014, 05:02 PM
ovalking ovalking is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2014
Posts: 1 ovalking User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 33 m 39 sec
Reputation Power: 0
Apologies for the thread resurrection, but I found this relevant topic while researching for my own league database.

I have some queries on dykebert's helpful starting point:


tblTeam
teamID - Primary key
teamName
teamManagerName
teamManagerEMail
teamManagerPhone
teamPoints

tblDivision
divisionID - Primary key
divisionName

tblDivisionTeam
div_teamID - Primary key
divisionID - Foreign key to tblDivison
teamID - Foreign key to tblTeam


i) I haven't understood the purpose of tblDivisionTeam.
On the basis that one Division has many teams I would have expected 'divisionID - Foreign key to tblDivison' to be in tblTeam.



tblMatches
matchID - Primary key
matchDate
homeTeamID - Foreign key to tblTeam
awayTeamID - Foreign key to tblTeam
*homeTeamPoints
*awayTeamPoints


ii) I note that tblMatches has a limitation in that it only allows 2 teams per match. I will need more flexibility (to cover multiple sports/event types). I'm thinking of splitting the table into two (as below). tblEvents would have a record for each match/event. tblResults would have a record for every team participation. Calculating event winners and league points may be more complicated though. I will want to record scores of individual events and calculate the necessary league points from them.

tblEvents
matchID - Primary key
Date
Venue

tblResults
matchID - foreign key to tblEvents
TeamName - foreign key to tblTeam
TeamScore
TeamLeaguePoints

Any thoughts on this issue would be appreciated.
Thanks, G.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesDatabase Development > League database


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap