question archive Assume that relation PROJ is horizontally fragmented in PROJ1 = δPNO ≤ "P2" (PROJ) PROJ2 = δPNO > "P2" (PROJ) Transform the following query into a reduced query on fragments: SELECT BUDGET FROM PROJ, ASG WHERE PROJ
Subject:Computer SciencePrice: Bought3
Assume that relation PROJ is horizontally fragmented in PROJ1 = δPNO ≤ "P2" (PROJ)
PROJ2 = δPNO > "P2" (PROJ)
Transform the following query into a reduced query on fragments:
SELECT BUDGET FROM PROJ, ASG
WHERE PROJ.PNO = ASG.PNO AND ASG.PNO = 'P4";