Achieve 3NF: Remove transitive dependencies (when a non-key attribute depends on another non-key attribute). Ensure that no non-key attribute is dependent on

nother non-key attribute.

For example:

• Original Table:

Employee_ID Employee_Nam

Department Department_Manager

1 Alice HR John

2 Bob IT Sarah

• ● 1NF: Remove repeating groups and ensure atomic values.
• 2NF: Remove partial dependencies. In this case, split into separate tables for

employees and departments.

• 3NF: Remove transitive dependencies. The Department_Manager is a dependency

on Department, not directly on Employee, so it should be moved to a separate table

for Departments.