Practice Exercises on Normalization

Problem 1

The OnlineStore wants to track employee information, including their department and manager.

An employee belongs to one department, and each department has one manager (who is also an employee). A poor design would be a single Employees table: (EmployeeID, EmployeeName, ...