Soccer/Football Database Design
Posted on 2005-03-24
this is more of a database question as opposed to a specific access question but I hope someone is still able to help me?
I am putting together a little database of my local soccer/football team. All i want to store is information about each match and player information. Some of my queries I would like would be how many games a player has played, scored, assisted etc..
I am just struggling on table setup and how I would create the queries. Im mainly unsure if i should store the player stats in the player table or create queries that would extract the information from the match tables?
Any help would be greatly appreciated.
Many thanks in advance, Alan.