Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    1

    Struggling with DB design for my first project!

    Hi All,

    My first project is a wrestling prediction forum (SAD I KNOW!).

    Anyway I'm struggling to come up with a decent DB design.

    The premise of the website is this...

    # Users register for the website.
    # Every month there is a big show which contains about 6 or 7 matches and they have to predict who is going to win those matches so they fill in a form to do this.
    # After the show I input who did actually win and then the users get feed back based on how many predictions they got correct.
    # Users will have a record of their predictions and results along with a score.
    # Will also be a leader board on the website as well.

    Now I'm struggling on how to actually keep the matches and predictions in the database.

    A show contains many matches and a match contains many wrestlers. So I'm guessing that's three tables right there already. The issue I'm having is how to actually store the predictions, how to store who actually won the matches and also how to store the users results as well! I'm completely stuck. Can anyone help please!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Predictions?
    I thought wrestling was fixed?
    Anyhoo....model the actual entities in your problem:

    Wrestlers
    Predictors
    Shows
    Matches
    Predictions

    What would be the attributes of these entities?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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