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'