The employee_norm table consists of data from employees, salaries, departments, dept_emp and titles table. Lets look at this table in detail:
| Table Column | Datatype | Description |
| emp_no | INT | Employee ID |
| birth_date | DATE | Date of Birth of Employee |
| full_name | STRING | Employee Full Name |
| gender | STRING | Gender of Employee |
| hire_date | DATE | Joining date of Employee |
| salary | INT | Salary of Employee for the period |
| from_date | DATE | Salary period start |
| to_date | DATE | Salary period end |
| dept_name | STRING | Department where the employee is working during this salary period |
| title | STRING | Designation of the employee during this time period |
With this knowledge of various tables in the Employee database we now have some understanding ...
