Prior to beginning work on this assignment, read Chapter $5$: Advanced Data Modeling and Chapter $6$: Normalization of Database Tables from the course text. This week you will develop the third task for the Online Food Ordering Database Final Project due in Week $5.$

If you designed separate tables for employee and department in your Week $2$ assignment, you will want to combine the employee and department tables before you begin this assignment. Your combined table should be called tbl$\_$employee. The tbl$\_$employee contains information about the employee and its department, and it contains the following fields $($you may also include other missing fields from your Week $2$ design$)$: employee$\_$id$,$ employee$\_$gender $,$employee$\_$salary, employee$\_$annual$\_$sallary, department$\_$name, department$\_$location, department head.

For this assignment, you will make use of the database normalization skills you have learned to normalize your database to the third normalization form. You will need to organize your columns and tables to reduce data redundancy and arrange attributes based on the relationships.