Consider the following normalized relations for a database in a large retail store chain: STORE (StoreID, Region,

Fantastic news! We've Found the answer you've been seeking!

Question:

Consider the following normalized relations for a database in a large retail store chain: STORE (StoreID, Region, ManagerID, SquareFeet) EMPLOYEE (EmployeeID, WhereWork, EmployeeName, EmployeeAddress) DEPARTMENT (DepartmentID, ManagerID, SalesGoal) SCHEDULE (DepartmentID, EmployeeID, Date) Assume that a data communications network links a computer at corporate headquarters with a computer in each retail outlet. The chain includes 75 stores with an average of 150 employees per store. There are 10 departments in each store. A daily schedule is maintained for five months (the previous two months, the current month, and next two months). Further assume that the following:

• Each store manager updates the employee work schedule for her or his store roughly 10 times per hour.

• An external payroll provider generates all payroll checks, employee notices, and other mailings for all employees for all stores.

• The corporation establishes a new sales goal each month for each department, in collaboration with the respective store managers.

• The corporation hires and fires store managers and controls all information about store managers; store managers hire and fire all store employees and control all information about employees in that store.

a. Would you recommend a distributed database, a centralized database, or a set of decentralized databases for this retail store chain?

b. Assuming that some form of distributed database is justified, what would you recommend as a data distribution strategy for this retail store chain?