Department / supervisor

[hooks]

Im having trouble determining where the supervisorID should go. Part of me thinks that it should go in the JobCodeMaster Table the other part of me thinks it should go in the DepartmentMaster Table. Any suggestions?

One other thing. Should i have a separate Supervisor table. Again im stuck on whether the supervisor is its own entity or just another employee?

thanks for the help.

Hooks

 

[hooks]

bump bump

 

[Sergeant]

I think the supervisor is just another employee. When you build a query, you can always put another copy of the employees table on the grid and link the supvID to the empID in the 2nd copy. If in doubt, look up "SELF JOIN"...it is the answer to the employee/supervisor dilemma.

 

[hooks]

Ive changed my layout a little. Can anyone find any problems with this layout. My goal is to make this employee management program as robust as possible.

The supervisor/Director is what i am worried about.


Thanks
Hooks

 

[hooks]

bump bump

 

[hooks]

The JobCodeMaster table is really a position table.

2. I wouldn't use tSupervisor and tDirector. I would use the tDepartmentMaster to identify supervisors and directors if I needed a list.

Makes sense. Thank you

3. It doesn't make sense for location to be in both the department and job tables. Location probably belongs in the department table unless you have people who work for the same department but are in different locations. Then I would put location in the employee record.

Good catch on that. I will remove the DeptLocationID from the DepartmentMaster table.

4. I also don't understand why the jobcode table contains deptID. Can a person really work for one department but have a jobcode that is linked to another?

I was thinking that i would need to link the JobCodeMaster table to the departmentMaster table to find all JobCodes for a particular Department. How else could i do this?


Thanks for your help with this.
Hooks

 

[hooks]

Here are my current relations