Question Three

You are provided with an initial table structure for an Employee Management System of a

medium$-$sized company. This table contains data about employees, their department, and their

project assignments.

Initial Table: EmploxeePrajects

This table is not normalized and contains several anomalies. Use the normalization process to

organize this data into well$-$structured tables that eliminate redundancy, insertion anomalies,

deletion anomalies, and update anomalies.

Tasks:

Identify Anomalies:

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

EmploxeeRrojects table.

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

Convert the table to $1NF$ 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 $1NF$ to $2NF.$ 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 $3NF$ 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.