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 $5$ months $($the previous $2$ months, the current month, and next $2$ months$).$

Further assume the following:

$-$ Each store manager updates the employee work schedule for their 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.

Create a memo to the chief information officer $($CIO$)$ addressing the following questions:

$-$What type of database should be used for this retail store chain $($e$.$g$.,$ distributed database, centralized database, or a set of decentralized database$)?$ Include examples, and develop a network chart to depict recommendation supporting written details.

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

$-$Explain to management the database factors involved in maintaining the database well$-$tuned and risk if the database is not tuned appropriately.

$-$Discuss key relative advantages for synchronous and asynchronous data replication and partitioning for distributed database design.

$-$Explain to management the importance of developing backup, recovery, and recovery facilities for the database.

$-$Explain key concepts, benefits, and challenges of data warehouses and data marts.