Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    How to represent roles in a database?

    Hi All,

    An entity can play different roles in a database. For instance, a person can be an employee of a company, and he/she can also be a part-time student of a university. So, this person plays two distinct roles at the same time. How could I embed this sort of fact into the database design effectively? My initial thoughts are to first create a table of available roles "ROLE" and then associate the "ROLE" with "PERSON" using a junction/many-to-many table "PERSON_PLAYS_ROLE". Is it a correct solution? Any better ideas?

    Thanks!

    Regards,
    Nathan

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    You can do that, if you need to be so generic. On the other hand you could be specific:
    PERSON -< EMPLOYMENT >- COMPANY
    PERSON -< ENROLLMENT >- UNIVERSITY

Posting Permissions

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