Question:
Consider the following normalized relations from a database in a large retail chain:
STORE (Store ID, Region, ManagerID, Square Feet)
EMPLOYEE (EmployeelD. WhereWork, EmployeeName, EmployeeAddress)
DEPARTMENT (DepartmentlD. ManagerlD SalesGoal)
SCHEDULE (DepartmenttD. EmployeelD. Date)
Answer these questions:
1. What opportunities might exist for denormalizing relations when defining the physical records for database?
2 Under what circumstances would you creating such denormalized records?