Q.1. Consider a relation that is fragmented horizontally by its plant number
emp(name , address, salary , plant number)
Assume that each fragmented has two replicas. One stored at the New York site & one stored locally at the plant site.
Write a query and describe good processing strategy for the following: At San Jose site
● Find all employee at Boca plant.
● Find the average salary of all employee.
● Find the lowest paid employee in the company.
Answers
Answer:
Consider the relations:
employee (name, address, salary, plant number)
machine (machine number, type, plant number)
Assume that the employeerelation is fragmented horizontally by plant number, and that each fragment is stored locally at its corresponding plant site. Assume that the machinerelation is stored in its entirety at the Armonk site. Describe a good strategy for processing each of the following queries.
a. Find all employees at the plant that contains machine number 1130.
b. Find all employees at plants that contain machines whose type is “milling machine.”
c. Find all machines at the Almaden plant.
d. Find employee  machine.
Step-by-step solution:
Step 1 of 4
Consider the given employee and machine relation where the former is fragmented horizontally by plant_number attribute.
Answer:
the plant site
Explanation:
colution of cis assignment two explain the difference between data replication in ... to the maintenance of a remote backup site? ... employee (name, address, salary, plant number) ... Assume that the employee relation is fragmented horizontally by plant number ... each fragment is stored locally at its corresponding plant site.