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

Question

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

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Databases DeMYSTiFieD

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question