Foreign Keys Either/Or Design

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bennett
    New Member
    • Jul 2007
    • 12

    Foreign Keys Either/Or Design

    Hi All

    I am just working on a database I need a little help with the logic, I have 3 tables for example

    Department
    Staff
    Resources

    I need to assign a resource to either / or a department or staff member is the correct way to do this add 2 foreign keys to the resources and make the foriegn keys non requied.

    Or do I need to use some kind of link table.

    Liam
Working...