I need the tables:
Database Before  Normalization

Database After Normalization

The tbl_employee contains information about the employee and its department, and it contains the following fields (you may also include other missing fields): 

employee_id, 

employee_gender 

employee_salary

employee_annual_salary

 

department_name

department_location

department head

 

 

Your combined table should be called tbl_employee.