Problem 78 Assume Relation Proj Fragmented Problem 76 Furthermore Relation Asg Indirectly Q43786506
Problem 7.8 (**). Assume that relation PROJ is fragmented as in Problem 7.6. Furthermore, relation ASG is indirectly fragmented as ASG, = ASG K PNO PROJ1 ASG2 = ASG KPNO PROJ2 %3D and relation EMP is vertically fragmented as EMP1 = IIENO,ENAME (EMP) EMP2 = IIENO,TITLE (EMP) %3D %3D Transform the following query into a reduced query on fragments: SELECT ENAME EMP,ASG, PROJ PROJ.PNO = ASG.PNO FROM WHERE PNAME = “Instrumentation” EMP. ENO = ASG.ENO AND AND 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 K PNO PROJ1 ASG2 = ASG KPNO PROJ2 %3D and relation EMP is vertically fragmented as
EMP1 = IIENO,ENAME (EMP) EMP2 = IIENO,TITLE (EMP) %3D %3D Transform the following query into a reduced query on fragments: SELECT ENAME EMP,ASG, PROJ PROJ.PNO = ASG.PNO FROM WHERE PNAME = “Instrumentation” EMP. ENO = ASG.ENO AND AND
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