Consider the data distribution of the COMPANY database,where the fragments at sites 2 and 3 are…

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper Order a Different Paper

Consider the data distribution of the COMPANY database,where the fragments at sites 2 and 3 are as shown in Figure23.3 and the fragments at site 1 are as shown in Figure 3.6.For each of the following queries, show at least twostrategies of decomposing and executing the query. Underwhat conditions would each of your strategies work well?a. For each employee in department 5, retrieve theemployee name and the names of the employee’s dependents.b. Print the names of all employees who work in department5 but who work on some project not controlled bydepartment 5.