Employee Relationship

[Jamie Flynn]

I am making a database that tracks each employee's stats
on a daily basis. The problem I have run into is if an
employee switches managers. I want the information about
each employee to be viewed under what manager they
currently are under or were under. Here are my tables:
Manager Table
-Manager Badge (Primary Key)
-Manager Name

Associate Table
-Associate Badge (Primary Key)
-Associate Name
-Manager Badge

How do I capture each associates stats under their manager
if their manager changes? Thank You!!

 

[Jeff Boyce]

Jamie

From your data structure (as described), your Associate (?employee) can only
have one manager. If true, I suppose you could simply change the
ManagerBadge when the Associate went to work for a new manager.

By the way, your structure and description seem to imply that Managers
aren't employees. It appears each employee has a badge, and some employees
are managers, but your data structure forces you to look in two tables to
find all employees.