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

    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
    Toronto, Canada
    that sure looks like a hierarchy of people

    here's the ERD --
    Attached Thumbnails Attached Thumbnails persons.bmp | @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