Need to generate football fixtures database

[Chimp8471]

I am after someone who can help me with a project, don't think it will be too difficult for someone with a bit of savvy, but way to complex for me...

here is what i need at this stage..

I need help to correctly design and link up my tables. I entered the info into them as best as i know how.

Rules.

We have 2 divisions
12 teams in division 2
14 teams in division 2
Teams sometimes share pitches
Some dates are reserved for certain game types (example county cup games take priority)

Can anybody please take a look at my structure and advise me where to go.

Outcome of finished application is to be:

generation of fixtures for a whole season for the 2 divisions and the cup games. games are sometimes cancelled so will need to be re generated at the next available date.

Teams play each other twice a season in the league

Teams should not play at home twice in the lague on consecutive weeks.

The biggest problem is the shared pitch issue...obviously ony 1 team can play on a specific pitch each week.

Cup games take priority on dates chosen for cups.. if team is out of the cup league fixture should be generaed

Extra dates will be fed into the generator later in the season to cater for midweek games.

Think thats about it...

Can anybody please help me.

 

[neileg]

Can you work it out on paper? If you can, you can do it in Access. If you can't, you can't.

 

[ctechnumber1]

I am not exactly sure what you want. Pardon my ignorance but can you please define the objects you plan on using (exactly what a pitch is and how it should interact with everything else)

example: Division consist of teams
I'm lost on fixture and pitch (familiar with American Football)

But what you are going to have to do is:

accurately represent the data to be used and model the tables based on that
I assure you what you are trying to do can be done
However, it will mostly likely require you to develop an algorithm that goes through all the requirements and builds a schedule.

please give me as much information as possible and I may be able to help you

thanks
go tartans

 

[Chimp8471]

ok sorry for that, i made the same mistake as usual...i assumed everyone knew what i was talking about!!! Truth is more often than noti don't even know what i am talking about

Definitions are as follows:

Teams - are the teams that will make up a fixture/schedule
Fixture - a fixture will be made up of 2 teams
Division - for a league to operate we have 2 divisions a number of teams in each division.
Division structure - we have 2 divisions called "Div 1" & "Div 2", Div 1 has 12 teams and div 2 has 13 teams
Fixture type- we play 2 types of fixture "League games" and "cup games"
League games - Teams in a division play each other 2 times in a season once at home and once away at the oppositions stadium.
Pitch- this refers to the stadium name. Each pitch may have more than one team that plays at the ground. example: "Admirals fc" and "tigers fc" both share the same pitch.
Cup games-think this will take some working out. we have a number of cups. we have a cup for "Div 1 teams" a cup for "Div 2 teams" and a Cup for "all teams in Div 1 and Div 2" the fixtures are made using a lottery style draw at a meeting, so i would need to enter these fixtures into the app,Cup games are played on a one off knock out basis. they do not play both home and away is what i mean here.
Fixture dates-Dates are set aside for a fixture to be played these are dominantly league fixtures however i also need to feed in the cup matches on set dates. however if a team is not in a cup game i need to look at giving them a league game against another team that is not playing on that date.
Closing dates- teams are allowed to close 2 dates throughout the season. this means they can choose not to play on a specific date. they need to give 30 days notice on this though.
Home and away fixtures: where possible teams should not play at home for 2 consecutive weeks in the league. cup games are not included in this rule. so it would be possible for a team to play a league game at home - then have a home cup game and then have a home league game again, as this would be spread over the 3 week period.
Shared pitch rules:a fixture is between 2 teams, at a teams pitch. Only one fixture can be played on a pitch on a given date.

Hope that explains things a little more....

Really appreciate any help you can offer.

 

[ctechnumber1]

Ok, that makes things much better. I will try to come up with a solution

 

[ctechnumber1]

Are you using Access 2003 or 2007??

 

[statsman]

Someone on this topic sent me a Personal Message regarding my "running totals" football stats package.

I'm sorry, I accidently deleted it before I could respond.

Please re submit to me.

 

[Alamo]

fixtures

It's Excel rather than Access but the programme at www.sportsfixturelists.com seems to do what you are after.