Practice Exercises on Normalization
Explore practical exercises on normalization to design efficient database schemas. Learn to decompose tables into third normal form, write SQL join queries for related data retrieval, and create denormalized summary tables to improve analytics performance in a sample OnlineStore database.
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, ...