Hello,

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?

do a search for supertype/subtype -- you'll want at least one more table

what's the difference between a boss and a manager?

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.