Problem 7. Assume that relation PROJ of the sample database is horizontally fragmented as follows:

Problem 7.6. Assume that relation PROJ of the sample database is horizontally

fragmented as follows:

PROJ1 = sPNO”P2″ (PROJ)

PROJ2 = sPNO>”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”

Leave a Reply