Assume the following view definition CREATE VIEW EMPVIEW(ENO, ENAME, PNO, RESP) AS SELECT EMP.ENO, EMP.ENAME, ASG.PNO, ASG.RESP FROM EMP, ASG WHERE EMP.ENO=ASG.ENO AND DUR=24 is accessed by...

Assume the following view definition CREATE VIEW EMPVIEW(ENO, ENAME, PNO, RESP) AS SELECT EMP.ENO, EMP.ENAME, ASG.PNO, ASG.RESP FROM EMP, ASG WHERE EMP.ENO=ASG.ENO AND DUR=24 is accessed by application q1, located at sites 1 and 2, with frequencies 10 and 20, respectively. Let us further assume that there is another query q2 defined as SELECT ENO, DUR FROM ASG which is run at sites 2 and 3 with frequencies 20 and 10, respectively. Based on the above

Dec 08, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here