Define in SQL -like syntax of the engineering database V (ENO<ENAME<JNO<RESP),?

[sumathi s]

Define in SQL -like syntax of the engineering database V (ENO<ENAME<JNO<RESP), where the duration is 24.Is view V updatable? Assume that relations E and G are horizontally fragmented based on access frequencies as follows:

Site 1 site 2 site 3
E1 E2
G1 G2

Where
E1=s title = engineering (E)
E2=s title = engineering (E)

G1=s 0 <DUR<36(G)
G2=s DUR>=36(G)
At which site(s) should the defination V be stored without being fulling replicated to increase localty of reference.