Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    11

    Unanswered: How to add staff and customer entity?

    I want to make a table where I can join these 4 relationships together..The thing is that a customer can ask many questions and staff can reply to the question and both can comment on the question..

    1 to m
    Question ------ Comment
    How to add staff and customer entity?

    Mine looks like this but i find my relationship is abit of odd



    Question - 1 ---m- Comment -m--------1-- Staff
    |
    | m
    |
    | 1
    |
    Customer
    Last edited by unknown80; 07-08-12 at 13:15.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
         
           PERSON      1       0,m
         (supertype) --------------- COMMENT            
              |
              | 1
              |
              |
          ____|____
         /         \
         | 0,1     |  0,1
         |         |
         |         |
      CUSTOMER   STAFF 
     (subtype)  (subtype)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2012
    Posts
    11
    Thanks again for the reply. I will see if I can add the answer into my database

Posting Permissions

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