Tasks:

Identify Anomalies:

Describe any insertion, deletion, and update anomalies present in the original EmployeeProjects table.

First Normal Form $(1$NF$)$:

Convert the table to $1$NF and explain the changes made to achieve $1$NF$,$ addressing any repeating groups and partial dependencies.

Second Normal Form $(2$NF$)$:

Progress the table from $1$NF to $2$NF$.$ Identify and remove any partial dependencies that do not meet the rules of $2$NF$.$ Explain which data was moved to new tables and the rationale behind these changes.

Third Normal Form $(3$NF$)$:

Move the table from $2$NF to $3$NF by eliminating transitive dependencies. Describe the transformation process and justify the creation of any new tables.

Final Schema:

Provide the schema of the final normalized tables, including primary keys and foreign keys for each table.

Reflective Analysis:

Discuss how normalization improves the integrity and efficiency of the database. Reflect on how the new schema supports better data management practices compared to the original table structure.