[AccessD] Table for Emp, Location, etc

...employees will inevitably have more than one supervisor/evaluator over
time and will themselves inevitably become supervisors or evaluators ...I'd
create a separate employee relationships table with a EmpRelID, EmpRelType
(Supv or Eval), DateFm, DateTo, SupEmpID (Superior Employee FK from
tblEmployee.EmpID) and SubEmpID (subordinate Emp FK from tblEmployee.EmpID)
...this approach allows you to not only track the current relationships but
answer such questions as who was his supervisor 2 years ago or how many
current emps have ever been evaluated by john doe.

William Hindman
What's the five-day forecast for Baghdad? Three days.

----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>;
<accessd at databaseadvisors.com>
Sent: Thursday, April 03, 2003 6:28 PM
Subject: Re: [AccessD] Table for Emp, Location, etc


> On 3 Apr 2003 at 8:57, Hollis,Virginia wrote:
>
> > On setting up a tables for employees, evaluators, their locations and
> > supervisors. Is it better to create a table for each (location,
> > employee, supervisor, evaluator) then in each table have the
> > locationID, supervisorID, etc. Or is it better to have each table &
> > join it together in one table with only the key fields, EmpID,
> > SupervisorID, LocationID, EvaluatorID?
> >
>
> Assuming that supervisors and evaluators are also employees who have their
own
> supervisors and evaluators:
>
> Just one table for personnel - tblEmployees.
> Include in the fields of this table two FKs -  SupervisorID and
EvaluatorID
> Use these to point to other records in the same table.
>
> LocationID points to records in a separate Locations table.
>
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>