NOTE - This will be an ACCESS DATABASE
OK, this might be a big task for me to tackle at such an inexperienced level - but I'm gonna do it, anyway.
I'm putting together a sports database. I have compiled a multitude of stats, and now I need to arrange them. Here's what I'm starting with...
I have 10 Excel Spreadsheets, representing 10 years of League play. Every year, obviously, has its own figures. Not all players play in all years. Not all players play on the same team in every season. Not all players have unique names. (there are a few with the same name, same spelling)
I have NO IDEA where to begin on this one. I am reading up on things like "primary keys", and "surrogate keys", and other things which have already made this daunting. My assumption is that I have to design my database with the query in mind. But that puts me into a continuous loop of confusion.
So here are a few of my fields. These are soccer stats:
Player | Team | Position | Games Played | Minutes Played | Goals Scored | Yellow Cards | Red Cards |
Now, this all has to be repeated for every season
I am assuming that because there can be more than one player with the same name, some other ID needs to be introduced, here? Is that correct? Because really, I have no other way to distinguish which player is which. (especially with the possibility of a team swap)
I'm going to stop typing for a minute, and start to take the feedback. For which, I thank you in advance...