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