Assume that relation proj of the texts sample database is


Assume that relation PROJ of the text's sample database is horizontally fragmented as follows:

PROJ1 = σPNO ≤ 'P2'(PROJ)
PROJ2 = σPNO > 'P2'(PROJ)

Transform the following query into a reduced query on fragments:

select ENO, PNAME
from PROJ, ASG
where PROJ.PNO = ASG.PNO
and PNO = 'P4'

 

 

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Assume that relation proj of the texts sample database is
Reference No:- TGS01123660

Expected delivery within 24 Hours