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.

In your paper,

• Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
• Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
• Describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms. Your description should be a minimum of 300 words.

The Online Food Ordering Database – Task 3 paper

• Must describe the three normalization forms and the guidelines in a minimum of 300 words and be formatted according to APA style as outlined in the Ashford Writing Center (Links to an external site.).
• Must include screenshots of database before and after normalization.
• Must include a screen shot, short description, and guideline of Task 3.
• Must include a separate title page with the following:
  • Title of paper
  • Student’s name
  • Course name and number
  • Instructor’s name
  • Date submitted
• Must use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
  • The Scholarly, Peer Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
• Must document all sources in APA style as outlined in the Ashford Writing Center.
• Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center.