Given the scenario and the requirements in Problem 2, answer the following questions:
a. What recommendations will you make regarding the type and characteristics of the required database system?
b. What type of data fragmentation is needed for each table?
c. What must be the criteria used to partition each database?
d. Design the database fragments. Show an example with node names, location, fragment names, attribute names, and demonstration data.
e. What type of distributed database operations must be supported at each remote site?
f. What type of distributed database operations must be supported at the headquarters site?