Consider a relation that is fragmented horizontally by plant-number:

Employee (name, address, salary plant-number) assumes that each fragment has two replicas: one stored at the New York site and one stored locally at the plant site. Describe a good processing strategy for the following queries entered at the San Jose site.

a. Find all employees at the Boca plant.

b. Find the average salary of all employees.

c. Find the highest-paid employee at each of the following sites: Toronto, Edmonton Vancouver Montreal.

d. Find the lowest-paid employee in the company.