Case Study 2 - Complete Pet Care

For a more complete description, see Case Study 4 under Chapter 22.
-Now assume that the relation Medication given in Question 20.4 is horizontally fragmented as follows:

Transform the relational algebra tree from Question 20.4 into a reduced query on fragments. Give a full explanation of the reasoning behind each step and state any transformation rules used during the reduction process.

Question

Case Study 2 - Complete Pet Care

For a more complete description, see Case Study 4 under Chapter 22.
-Now assume that the relation Medication given in Question 20.4 is horizontally fragmented as follows:
 
 Transform the relational algebra tree from Question 20.4 into a reduced query on fragments. Give a full explanation of the reasoning behind each step and state any transformation rules used during the reduction process.

Quizplus · Accepted Answer

The Answer of Case Study 2 - Complete Pet Care

For a more complete description, see Case Study 4 under Chapter 22.
-Now assume that the relation Medication given in Question 20.4 is horizontally fragmented as follows:
 
 Transform the relational algebra tree from Question 20.4 into a reduced query on fragments. Give a full explanation of the reasoning behind each step and state any transformation rules used during the reduction process.