The titles table consists of all the roles of employees from a given date to end date. More details are shown as follows:
Table Column | Datatype | Description |
emp_no | INT | Employee Id |
title | STRING | Designation of the employee |
from_date | DATE | Starting date from which employee has assumed this role |
to_date | DATE | Last date where the employee has performed this role |