Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    3

    Database design review

    Hello Everybody

    This my first post. I'm totally new to the world of databases. I'm still learning, and I would like to create a database for a site of local events(sport music). The idea is kind of stupid, i would just want to know if it's technically correct.

    First i have the Table of members :

    memberID username password signupDate email country City ID


    Then the Tables of the cites : ( i know it is kind of useless)

    CityID nameOfCity country



    Then the table of all the events:

    nameOfEvent EventID cityID restricted(bool) TypeOfTheEvent


    Then the table for each member :

    UserID eventID Accepted (bool)


    And finally the table for each event:

    EventId UserID accepted (bool) InviteOthers (bool) Rating of the event


    So as you see, I want to create a table for eache member, and for each event. I don't know if it's a good thing...
    Please, would you help me correct this database, or just give me some advices?

    Thanks in avance

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by ZMZ View Post
    So as you see, I want to create a table for eache member, and for each event. I don't know if it's a good thing...
    it isn't

    all you need is one table for member events, that will have two columns as the primary key -- memberid and eventid

    also, your cities table is, as you guessed, kind of useless
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2010
    Posts
    3
    Thanks, I'm going to correct that.

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
  •