[solved]-10 Following Table Structure Contains Staff Data Needs Normalized Stored Relational Databa Q39075780

10. The following table structure contains staff data that needs to be normalized and stored into a relational database. Normalize the database up to the third normal form (3NF). emplo empName empPhone empPositionID empPosition Descipt empNextRaiseDate empSalary a. Create a table that can store the staff data with emplD as the primary key. b. Follow normalization rules discussed to show 1NF, 2NF, and 3NF for each table created. Your SQL statement should also show how the tables are related or linked to each other by establishing the primary and secondary keys relationship. Show transcribed image text 10. The following table structure contains staff data that needs to be normalized and stored into a relational database. Normalize the database up to the third normal form (3NF). emplo empName empPhone empPositionID empPosition Descipt empNextRaiseDate empSalary a. Create a table that can store the staff data with emplD as the primary key. b. Follow normalization rules discussed to show 1NF, 2NF, and 3NF for each table created. Your SQL statement should also show how the tables are related or linked to each other by establishing the primary and secondary keys relationship.

Expert Answer

---

Answer to 10. The following table structure contains staff data that needs to be normalized and stored into a relational database…. . . .