Q1: (10 Points) Consider the following engineering database DUR 12 10 18 FMP ENO ENAME TITLE ENO PNO RESP E1 J. Dnes Elmet. Eng Manager M. Smith Byet. Anal P1 Analyst Mach Eng P2 Analyst E4 J. Miller Progrummer Consultant F R CARRY Syrt Anal Fa P4 Enginner EES L Chu Elut. Eng Programmer F7 R Davis Mach Engi P2 Manager LS J. Jones Bymt. Anul Le Engineer P3 Mondrier PROJ PAY PNO PNAME BUDGET LOC TITLE P1 Instrumentation 10000 Montreal El ng P2 Database Dovolop 135000 New York Syet Anal P3 CAD/CAM 2500DD New York Muus. Eng. PG Maintenance 310000 Paris Programmer 435 40 4UUUU 34000 27Uu 2000 Assume the following view definition: CREATE VIEW EMPVIEW (ENO, ENAME, PNO, RESP) AS SELECT E. ENO, E. ENAME, ASG.PNO, ASG.RESE FROM EME, 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 DUR 12 10 18 FMP ENO ENAME TITLE ENO PNO RESP E1 J. Dnes Elmet. Eng Manager M. Smith Byet. Anal P1 Analyst Mach Eng P2 Analyst E4 J. Miller Progrummer Consultant F R CARRY Syrt Anal Fa P4 Enginner EES L Chu Elut. Eng Programmer F7 R Davis Mach Engi P2 Manager LS J. Jones Bymt. Anul Le Engineer P3 Mondrier PROJ PAY PNO PNAME BUDGET LOC TITLE P1 Instrumentation 10000 Montreal El ng P2 Database Dovolop 135000 New York Syet Anal P3 CAD/CAM 2500DD New York Muus. Eng. PG Maintenance 310000 Paris Programmer 435 40 4UUUU 34000 27Uu 2000 Assume the following view definition: CREATE VIEW EMPVIEW (ENO, ENAME, PNO, RESP) AS SELECT E. ENO, E. ENAME, ASG.PNO, ASG.RESE FROM EME, 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