Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Smile Need Help on ERD

    Hello everyone,
    I am stuck up with ERD design. I need your help. Following is the scenario.

    Admin can create partners. (Admin can create many partner)
    partner contains clients. (One partner contains many clients)
    one client can create many user.
    Admin can also create clients but under any particular partner.
    Admin or partner can also add users under any particular client.
    How to show relationship between these entities (Admin, partner, client and user.)

    Please help me out in ERD. I am new for database design

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that sure looks like a hierarchy of people

    here's the ERD --
    Attached Thumbnails Attached Thumbnails persons.bmp  
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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