Problem 78 Assume Relation Proj Fragmented Problem 76 Furthermore Relation Asg Indirectly Q43786538
Problem 7.8 (**). Assume that relation PROJ is fragmented as in Problem 7.6. Furthermore, relation ASG is indirectly fragmented as ASG, = ASG XPNO PROJ1 ASG2 = ASG KPNO PROJ2 %3D and relation EMP is vertically fragmented as EMP1 = IIENO,ENAME (EMP) EMP2 = IIENO,TITLE (EMP) %3D Transform the following query into a reduced query on fragments: SELECT ENAME EMP,ASG, PROJ PROJ.PNO = ASG.PNO PNAME = FROM WHERE AND “Instrumentation” AND EMP. ENO = ASG.ENO Show transcribed image text Problem 7.8 (**). Assume that relation PROJ is fragmented as in Problem 7.6. Furthermore, relation ASG is indirectly fragmented as ASG, = ASG XPNO PROJ1 ASG2 = ASG KPNO PROJ2 %3D and relation EMP is vertically fragmented as
EMP1 = IIENO,ENAME (EMP) EMP2 = IIENO,TITLE (EMP) %3D Transform the following query into a reduced query on fragments: SELECT ENAME EMP,ASG, PROJ PROJ.PNO = ASG.PNO PNAME = FROM WHERE AND “Instrumentation” AND EMP. ENO = ASG.ENO
Expert Answer
Answer to Problem 7.8 (**). Assume that relation PROJ is fragmented as in Problem 7.6. Furthermore, relation ASG is indirectly fra…
OR