Soccer Database structure

[geordie]

Firstly hello everyone,

I have had a search through the forums for notes posted about creating a soccer database to track results, fixtures, players, and will download some of the example databases in time.

I am in a similar position where i would like to create a database/application that allows users to view Results, Fixtures and other club information.

My main area is knowing how many tables to have and what the structure of these tables should be (relationships etc.). I would like to keep a track of the goalscorer(s) for each game for both the home and away teams. I am going to use this information to display stats such as topscorer and average goals scored in a game I was thinking about having two tabels HomeScorers and AwayScorers that are exactly the same in structure:

GameID
Player
Minute

I want t be able to display the information regarding goal scorers on a form in the format: scorer1 12, scorer2 minute

I am really struggling to figure out how to create such a structure and in fact if Access will let me do this.

Can someone help?

 

[KenHigg]

I would suggest going to a book store, look at the Access books for the version of Access you have, look in the index for 'Entities' and 'Attributes' and buy one that cover these topics. This forum is best used as a last resort when debugging Access db's, or as place to get second opinions when you are faced with making major design decisions, not as a primary source of information on how to build Access db's... (This, of course, is just my, humble opinion)

 

[Mile-O]

Do a search on soccer/football database - it's a regular subject.