Question: AS Problem 3.8 (**). Assume the following view definition CREATE VIEW EMPVIEW (ENO, ENAME, PNO, RESP) SELECT EMP.ENO, EMP.ENAME, ASG.PNO, ASG. RESP FROM EMP, ASG

 AS Problem 3.8 (**). Assume the following view definition CREATE VIEW

AS Problem 3.8 (**). Assume the following view definition CREATE VIEW EMPVIEW (ENO, ENAME, PNO, RESP) SELECT EMP.ENO, EMP.ENAME, ASG.PNO, ASG. RESP FROM EMP, ASG WHERE EMP.ENO-ASG.ENO AND DUR-24 is accessed by application q, located at sites 1 and 2, with frequencies 10 and 20, respectively. Let us further assume that there is another query 92 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 information, construct the use(9,A;) matrix for the attributes of both relations EMP and ASG. Also construct the affinity matrix containing all attributes of EMP and ASG. Finally, transform the affinity matrix so that it could be used to split the relation into two vertical fragments using heuristics or BEA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!