SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Oct 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Absolute Newbie to Databases - Need Some Newbie Help

    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...

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,998
    Mentioned
    100 Post(s)
    Tagged
    0 Thread(s)
    You need to break it down into a number of tables, some will represent an entity such as a player or game and some will be "linking" tables. A Few ideas for tables:

    Player: Each record represents one player, with fields for their name, gender, date of birth, date they joined the league, etc
    Team: Each record represents one team with fields for things like, team nickname, mascot name, ground/pitch location, manager, etc
    Player-Team: Records when a player joined a team and when they left a team
    Manager: Records details about a teams manager (maybe known as a coach in some sports)
    Manager-Team: Basically the same as Player-Team but for each manager

    Can you please post a complete list of the column headings?

    Have a read of these two wikipedia articles:
    Relational Databases
    Database Normalization
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Member
    Join Date
    Oct 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by SpacePhoenix View Post
    You need to break it down into a number of tables, some will represent an entity such as a player or game and some will be "linking" tables. A Few ideas for tables:

    Player: Each record represents one player, with fields for their name, gender, date of birth, date they joined the league, etc
    Team: Each record represents one team with fields for things like, team nickname, mascot name, ground/pitch location, manager, etc
    Player-Team: Records when a player joined a team and when they left a team
    Definitely understand this, and am on the same page. Just very confused how to accomplish it.

    Quote Originally Posted by SpacePhoenix View Post
    Can you please post a complete list of the column headings?
    For now I would like to assume that I have given you the complete heading. I want to construct a simple database, based on only the data that I've given so far. It actually encompasses all of my difficulties. All of the rest of the columns are statistics similar those shown to right of "Position", and the list is HUGE.

    Quote Originally Posted by SpacePhoenix View Post
    Have a read of these two wikipedia articles:
    Relational Databases
    Database Normalization
    Thank you for the links.

  4. #4
    SitePoint Member
    Join Date
    Oct 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hopefully, this gives a better clue what I want to accomplish....

    Here is what I hope to achieve with the database:

    Master_Table.jpg

    Whereas this is what I have right now: (representing one spreadsheet for every season)

    Player | Club | Apps | Goals
    ------------------------------------------------------
    Player_Name | club_1 | x | x


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •