I have a recursive relationship with many to many as follows. Employee table. An employee may be supervised by many other employee and an employee may supervise many other employees. How do I implement this business requirement.
Please give me your ideas.
04-22-2002, 12:46 PM
There is a resolution entity, call it MGR_EMP. It has two columns, MGR_ID and EMP_ID. Both have FKs to the EMP_ID in the EMP table.
An employee has 0 or many MGR_EMP relations and an employee manages through 0 or many MGR_EMP relations.