Question

Define in SQL-like syntax a view of the engineering database V(ENO, ENAME, PNO, RESP), where the duration is 24. Is view V updatable? Assume that relations EMP and ASG are horizontally fragmented based on access frequencies as follows: At which site(s) should the definition of V be stored without being fully replicated, to increase locality of reference?

Answer 1

Answer:

Explanation:esc EMP;

the table with its constrains will appear.