Consider the following engineering database

Assume the following view definition: CREATE VIEW EMPVIEW(ENO, ENAME, PNO, RESP) AS SELECT E.ENO, E. 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 information, construct the matrix for the attributes of both relations EMP and ASG. Also construct the affinity matrix containing all attributes of EMP and ASG.

ASG EMP ENO ENAME TITLE ENO PNO RESP DUR 12 E1 J. Doe E2 M. SmithSyst.Anal. E3 A. Lee E4 J. Miller Programmer ES B. CaeySyst Anal. E6 L Chu Elect. Eng. E7 R DaMech. Eng. E8 J.JonesSyst Anal. E1 P1 Manager E2 P1 Analyst Elect. Eng E2P2 Analyst Mech. Eng. E3 P3 Consultant E3 P4Engineer E4 P2 | Programmer 10 48 18 P2 Manager E6 P4 Manager E7 P3 Engineer 48 36 40 E8 P3 Manager PAY PROJ PNO PNAME BUDGET LOC TITLE 150000 Montreal Elect. Eng. P1 Instrumentation P2 Database Develop. 135000 NewYork P3 CAD/CAM Syst.Anal. 34000 250000 NewYork 310000 Paris Mech. Eng Programmer P4 Maintenance 24000 Figure 1: Database ASG EMP ENO ENAME TITLE ENO PNO RESP DUR 12 E1 J. Doe E2 M. SmithSyst.Anal. E3 A. Lee E4 J. Miller Programmer ES B. CaeySyst Anal. E6 L Chu Elect. Eng. E7 R DaMech. Eng. E8 J.JonesSyst Anal. E1 P1 Manager E2 P1 Analyst Elect. Eng E2P2 Analyst Mech. Eng. E3 P3 Consultant E3 P4Engineer E4 P2 | Programmer 10 48 18 P2 Manager E6 P4 Manager E7 P3 Engineer 48 36 40 E8 P3 Manager PAY PROJ PNO PNAME BUDGET LOC TITLE 150000 Montreal Elect. Eng. P1 Instrumentation P2 Database Develop. 135000 NewYork P3 CAD/CAM Syst.Anal. 34000 250000 NewYork 310000 Paris Mech. Eng Programmer P4 Maintenance 24000 Figure 1: Database