Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2013
    Posts
    3

    Help me with database design

    i use mysql with phpmyadmin.
    i have 2 tables. Users and players.

    scenario is : players gain points based on performance. and users select team consists of 10 players. just like fantasy football.so how to design mysql database for this.

    user(details, team[10], points),
    players(details, points,values);

    is this correct? if yes how to do this in phpmyadmin.
    pls help .
    thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Seems you have at least three entities (users, players, teams), but only two tables.
    If it's not practically useful, then it's practically useless.

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

  3. #3
    Join Date
    Aug 2013
    Posts
    3
    thanks for reply.
    so what should be attributes for teams entity then?
    some one suggested me foreign key or something. confused?
    help.
    thanks

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    At minimal, a TeamName and a foreign key to the User who created the team.
    If it's not practically useful, then it's practically useless.

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

Tags for this Thread

Posting Permissions

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