[AccessD] Table for Emp, Location, etc

Each employee has one supervisor, one location, one evaluator, one
workstation
 
Each evaluator has one location, one supervisor, and evaluates many
employees
>An Evaluator be an Employee or Supervisor? Possible - but very rare

-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com]
Sent: Thursday, April 03, 2003 9:10 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Table for Emp, Location, etc


That depends on whether an object can have more than one Location,
Supervisor etc.  Your second solution allows as many combinations as you
need.  The first allows each to have one.
 
I would think you would have:
 
Employees
Evaluators
Locations
and Supervisors
 
Assuming:
 
Each Employee has one supervisor, then the Employee table has a Foreign Key
SupID
Each Employee has one location, then the Employee table has a FK LocID
Each Employee has one Evaluator, then the Employee table has a FK EvID
 
You haven't really expressed the relationships of all the objects.  Do
Evaluators have locations?  Do supervisors have locations?  Only one?  If
only one then an ID field directly in the Evaluator table to relate the
Evaluator to the location.  If more than one, then a M-M table relating the
evaluator to many locations.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hollis,Virginia
Sent: Thursday, April 03, 2003 9:58 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Table for Emp, Location, etc


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?
 
Virginia

  _____  

Is email taking over your day? Manage your time with eMailBoss. Try it free!
http://www.eMailBoss.com <http://www.eMailBoss.com> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030403/3a27f117/attachment-0001.html>