Originally Posted by
Minty
As a suggestion, you don't really need the supervisor table, as I would assume that any supervisor is also an employee.
So simply store the EmployeeId as the SupervisorID in your Employees table.
If you need to record Who supervised who over time then you will need a third table, with EmployeeID,SuperId(Which is actually the EmpID of the supervisor), StartEnd and EndDate
I'm also confused as to why you have an ID field and and EmpID field in your employees table. Are they not the same thing, or is it a Payroll number type thing?