I have a database that is laid out like this:
http://img244.imageshack.us/img244/4674/dbri6.jpg
I have 17 teams entered into the teams table, divided into 2 conferences, with 2 divisions in each conference. A team plays 15 games a season. ( 15 weeks, 1 game a week ). With 17 teams there are 4 teams per divison, with one division having 5, so i will have to create a dummy team for BYES.
The user will enter in the following data:
1. The minimum amount of inter divison games.
2. The minimum amount of inter conference games.
3. The minimum amount of cross conference games.
anyone got some ideas on this? I have some of my own but I would like the opinion of others. thanks ;o
Round Robin Sports Scheduling Algorithm. HELP!
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: Round Robin Sports Scheduling Algorithm. HELP!
How is this relative? I only ask so I have an understanding of what you want.ZeroFear wrote:The user will enter in the following data:
1. The minimum amount of inter divison games.
2. The minimum amount of inter conference games.
3. The minimum amount of cross conference games.
the inter divison games are the most important, since they are playing for #1 seed in there divison so they can go to playoffs. If people in a divison never play other people in there own divison, just people from other conferences and divisions, how does that make them the best team in there OWN divison. Thats why the user ( leauge manager ) can set the min number of times people play in there own divison, conference, and inter conference. I think i might do only a var that sets inter divison games.