Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    3

    multiple relations between two tables

    I read all threats about multiple relations on the forum. but I did not find answer my question.

    I want to design a petition database,
    entities;
    "user" & "petition"

    relations;
    1) compose: "users can compose several petitions. every petition must belong to one user"
    2) sign: "users can sign any petition for one time. a petition can include several user sign"

    I do something but I feel there is something wrong... (you can see it attached image)

    my questions;
    1) how must be the tables and relations in this case?
    2) do you know complete example about petition database?

    If you could guide me, I will be very happy

    sorry for my bad english.
    thank you
    Attached Thumbnails Attached Thumbnails db.png  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that model looks okay to me

    why do you feel there is something wrong?

    by the way, your english is fine
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2011
    Posts
    3
    thank you for your answer dear r937,

    I dont know. I am very newbie about database design...
    Only feeling. I am not sure if its possible to define multible relations like this.
    I do not want to face some problems while I run sql queries..

    you said that multiple relations like this is possible and in accordance with database design consept and rules...?

    thank you again...

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by maximus___ View Post
    you said that multiple relations like this is possible and in accordance with database design consept and rules...?
    yes

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2011
    Posts
    3
    thank you very much dear r937

Posting Permissions

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