The dept_manager table has records about Employee acting as manager for a given department. More details are in this table:
Table Column | Dataype | Description |
emp_no | INT | Employee ID who is acting as manager for this department |
dept_no | STRING | Department ID |
from_date | DATE | Starting date from which Employee is acting as Manager for this department. |
to_date | DATE | Ending date till where the Employee has acted as Manager for this department. |