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 employees dependents.b. Print the names of all employees who work in department5 but who work on some project not controlled bydepartment 5.
Our writing company offers a unique service that provides guidance in different types of assignments. Please rest assured that the service is absolutely legal and doesn’t violate any regulations. It can be used for generating new ideas and thoughts for your own project, additional insight into the subject, or encouragement for further researches.