STORE $($StoreID$,$ Region, ManagerID, SquareFeet$)$

EMPLOYEE $($EmployeeID$,$ WhereWork, EmployeeName,

EmployeeAddress$)$

DEPARTMENT $($DepartmentID$,$ ManagerID, SalesGoal$)$

SCHEDULE $($DepartmentID$,$ EmployeeID, Date$)$

What opportunities might exist for denormalizing these

relations when defining the physical records for this

database? Under what circumstances would you consider

creating such denormalized records?