Homework answers / question archive / Prior to beginning work on this assignment, read Chapter 5: Advanced Data Modeling and Chapter 6: Normalization of Database Tables from the course text

Prior to beginning work on this assignment, read Chapter 5: Advanced Data Modeling and Chapter 6: Normalization of Database Tables from the course text

Computer Science

Share With

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.