1. Consider the Engineering firm data model that we are using in class and assume that...

Transcribed Image Text:

1. Consider the Engineering firm data model that we are using in class and assume that EMP and ASG relations are distributed across three sites as shown below: Site 1 Site 2 Site 3 EMP₁ EMP 2 ASG₁ ASG₂ Where: EMP 1 = OTITLE="Engineer" (EMP) EMP2 = OTITLE="Engineer" (EMP) ASG100<DUR<360 R<36 (ASG) ASG2 ODUR236 (ASG) = (a) Define in SQL-like syntax a view of the engineering database V(ENO, ENAME, PNO, RESP), where the duration is 24. (b) Is view V up dat able? (c) At which site (s) should the definition of V be stored without being fully replicated, to increase locality of reference? (d) Express the following query: names of employees in view V who work on the CAD/CAM project. 1. Consider the Engineering firm data model that we are using in class and assume that EMP and ASG relations are distributed across three sites as shown below: Site 1 Site 2 Site 3 EMP₁ EMP 2 ASG₁ ASG₂ Where: EMP 1 = OTITLE="Engineer" (EMP) EMP2 = OTITLE="Engineer" (EMP) ASG100<DUR<360 R<36 (ASG) ASG2 ODUR236 (ASG) = (a) Define in SQL-like syntax a view of the engineering database V(ENO, ENAME, PNO, RESP), where the duration is 24. (b) Is view V up dat able? (c) At which site (s) should the definition of V be stored without being fully replicated, to increase locality of reference? (d) Express the following query: names of employees in view V who work on the CAD/CAM project.

Answer rating: 100% (QA)

Assuming we have the following tables and their attributes in our Engineering firm data model EMP ta... View the full answer