Results 1 to 5 of 5

Thread: Your Opinion

  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: Your Opinion

    Im creating a website which is a online text based game... i was wondering what is more logical out of these options:

    should i create a table for example to do with user's info like:
    A) All of it in one table
    or
    B)Registration details under one table
    Game exp under another
    stats under another etc

    Which one is most smartest to do and is there any down sides to doing one or the other from those options.. ive never done it before so wanted to know from people who may have tried both ...

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    multiple tables depending on data. search on normalization.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    http://r937.com/relational.html courtesy of r937 who is a frequent user of these forums.
    George
    Home | Blog

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    courtesy of paul litwin, who wrote the article and gave me permission to post it on my site
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Have a look at E-R (entity relationship) diagrams. You will find they help to visualise the normalisation work you are doing.

Posting Permissions

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