Q1: (10 Points) Consider the following engineering database EMP ASG ENO ENAME TITLE ENOPNO RESP DUR E 1 E2 E3 E4 E5 E6 E7 C8 J. Doe Elect. Eng M. Smith Syst. Anal A. Lee Mech. Eng J. Miller Programmer B. Casey Syst. Anal. L. Chu Elect. Eng R. Davis Mech. Eng J. Jones Syst. Anal. E 1 E2 E2 E3 E3 E4 E5 E6 EZ E8 P1 P1 P2 P3 P4 P2 P2 P4 P3 P3 Manager Analyst Analyst Consultant Engineer Programmer Manager Manager Engineer Manager PAY TITLE 12 24 6 10 48 18 24 48 36 40 PROJ PNO PNAME BUDGET LOC SAL P1 P2 P3 P4 Instrumentation 150000 Montreal Database Develop. 135000 135000 New York CAD/CAM 250000 New York Maintenance 310000 Paris Elect. Eng Syst. Anal. Mech. Eng Programmer 40000 34000 27000 24000 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. Q1: (10 Points) Consider the following engineering database EMP ASG ENO ENAME TITLE ENOPNO RESP DUR E 1 E2 E3 E4 E5 E6 E7 C8 J. Doe Elect. Eng M. Smith Syst. Anal A. Lee Mech. Eng J. Miller Programmer B. Casey Syst. Anal. L. Chu Elect. Eng R. Davis Mech. Eng J. Jones Syst. Anal. E 1 E2 E2 E3 E3 E4 E5 E6 EZ E8 P1 P1 P2 P3 P4 P2 P2 P4 P3 P3 Manager Analyst Analyst Consultant Engineer Programmer Manager Manager Engineer Manager PAY TITLE 12 24 6 10 48 18 24 48 36 40 PROJ PNO PNAME BUDGET LOC SAL P1 P2 P3 P4 Instrumentation 150000 Montreal Database Develop. 135000 135000 New York CAD/CAM 250000 New York Maintenance 310000 Paris Elect. Eng Syst. Anal. Mech. Eng Programmer 40000 34000 27000 24000 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