HINT: The answer for this question is on Course Hero. I just don't have access to it. If you have it please paste your answer here. Thank you.

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