Assignment

Normalizing a denormalized table representing employee information in a company database. The current table contains redundant data and violates normalization rules. Normalize this table up to the Third Normal Form $(3$NF$)$ by creating new tables and defining appropriate primary keys, foreign keys, and functional dependencies.

Denormalized Employee Information Table:

$\backslash$table$[[$EmployeeID$,$EmployeeName,Department,ManagerID,ManagerName,Location$],[101,$Alice,Sales,$100,$Bob,New York$],[102,$Bob,Marketing,$100,$Bob,New York$],[103,$Charlie,Sales,$100,$Bob,New York$],[100,$David,Management,NULL,NULL,Chicago$]]$