Data modeling for employee has multiple managers

database-designoracle

I've referred this link for modelling the table for employee-manager relationship. However, in my use case, an employer can have multiple managers. I am wondering what would be the best solution for this. Any suggestions for modelling this use case?

Best Answer

That sounds like a many to many relationship where you need a bridge table. You would store everyone in an employee table with an ID and then have a separate hierarchy table with manager and employee combinations.