ii) Define in SQL-like syntax a view of the engineering database V(ENO, ENAME, PNO, RESP), where the duration is 24. Is view V updatable? Assume that relations EMP and ASG are horizontally fragmented based on access frequencies as follows: Site 1 Site 2 Site 3 EMP, EMP2 ASG ASG2 where EMP, = OLE "Engineer (EMP) EMP2 = TITLE="Engineer" (EMP) ASG = Oo36(ASG) At which site(s) should the definition of V be stored without being fully replicated, to increase locality of reference? 1.5M ii) Define in SQL-like syntax a view of the engineering database V(ENO, ENAME, PNO, RESP), where the duration is 24. Is view V updatable? Assume that relations EMP and ASG are horizontally fragmented based on access frequencies as follows: Site 1 Site 2 Site 3 EMP, EMP2 ASG ASG2 where EMP, = OLE "Engineer (EMP) EMP2 = TITLE="Engineer" (EMP) ASG = Oo36(ASG) At which site(s) should the definition of V be stored without being fully replicated, to increase locality of reference? 1.5M