1- Find out the total costs for following distributed execution strategies given the values

a. size(EMP) = 750, size(ASG) = 1000

b. tuple access cost = 2 unit; tuple transfer cost = 5 units

Which of the strategies works better? Please elaborate.

Note: We assume that relations EMP and ASG have 750 and 1000 tuples, respectively,

and that there are 20 managers in relation ASG. We also assume that data is

uniformly distributed among sites. Finally, we assume that relations ASG and EMP

are locally clustered on attributes RESP and ENO, respectively. Therefore, there is

direct access to tuples of ASG (respectively, EMP) based on the value of attribute

RESP (respectively, ENO).