Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009

    ISA relationship question


    I've a small question about how to achieve the following:

    I have an ISA relationship as follows:

    - salesperson
    - manager
    - boss

    they are all employees of my company, however. A salesperson can work at different stores of my company and the boss and manager can only work at one store. How a can I achieve this?

    Cause my employee entity has connection with store with a certain constraint, or do I need to look at otherwise and use connection from salesperson to connect to store, cause there is actually only one boss so, I think that would be my approach to tackle this problem.

    Any suggestions?

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    do a search for supertype/subtype -- you'll want at least one more table

    what's the difference between a boss and a manager? | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2009
    Yeah, good question. I do not really know... but I wanted some difference between the boss and a manager.

    PS: I will look it up and respond to you as soon as possible.
    Last edited by temp_tsun; 03-13-10 at 13:46.

Posting Permissions

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