feasible database design?

[20sunflower]

Hi

Would fixtures for a sports league be a feasable database? I could have table players, table league fixtures, table game scores and then make a report of results/performance including outstanding matches. Does this sound workable or is it better done in Excel?

Thanks

 

[gemma-the-husky]

certainly easy enough in access- and access is better for this than excel, I would think -
but it probably isn't trivial - especially recording player's details.

eg - think about how you would manage transfers of a player from one team to another.

 

[20sunflower]

certainly easy enough in access- and access is better for this than excel, I would think -
but it probably isn't trivial - especially recording player's details.

eg - think about how you would manage transfers of a player from one team to another.

I am only doing a database for a singles league to avoid that problem. My database doesn't have to be complex, just as long as it has 2 relationships, 2 forms, 2 reports, a macro, a query and a switch board.

 

[gemma-the-husky]

sorry, i was thinking you meant like a soccer league - i see what you mean.

as I say, I shouldn't think it's an incredibly hard project, and a database would definitely be more workable than a spreadsheet - but it needs some thought to get the structure right.

don't think of it in terms of the numbers of forms/queries etc. I am 100% sure you need more than 2 of each anyway. Get the table layout right, and the queries and forms will almost design themselves.

 

[Lightwave]

20sunflower

I did this in a bit of an amateur way for a squash league I was involved in

Have a look at this.

http://www.access-programmers.co.uk/forums/showthread.php?t=105677

I did a bit of research and managed to find some code from a talented programmer called Dev Ashish (name originally posted wrong retrospectively corrected see vbaInet post)

Storing the players the games and the scores is actually really quite easy if you have some experience in database design.

Working out fixtures or automatically generating fixtures is actually really complicated and requires a good knowledge of both visual basic and combinative mathematics. I managed to get it working for my purposes but has its eccentricities.

This might be a good starting point for your database.

 

[vbaInet]

... I did a bit of research and managed to find some code from a talented programmer called Dev Aviv ...

Dev Ashish

http://www.mvps.org/access/

 

[20sunflower]

I am quite confused by the database relationships I need to set up. Can someone help me please?

I have a table that holds the basic information for each player-membership ID, First name, last name, Date of Birth, Address, Contact number

Then I have a table with the scores that each player gets in each game (All players play 3 games in each match)

Now I want to connect the game score table to a league table to show the player rankings. However, the part I'm struggling with is working out how to make players have an opponant.