Problem 3. Consider relations EMP and PAY in Figure 3. EMP and PAY are horizontally fragmented as follows: EMP1 = sTITLE=quot;Elect.quot;(EMP) EMP2…

Problem 3.3. Consider relations EMP and PAY in Figure 3.3. EMP and PAY arehorizontally fragmented as follows:EMP1 = sTITLE=”Elect.Eng.”(EMP)EMP2 = sTITLE=”Syst.Anal.”(EMP)EMP3 = sTITLE=”Mech.Eng.”(EMP)EMP4 = sTITLE=”Programmer”(EMP)PAY1 = sSAL30000(PAY)PAY2 = sSAL<30000(PAY)Draw the join graph of EMP nTITLE PAY. Is the graph simple or partitioned? If itis partitioned, modify the fragmentation of either EMP or PAY so that the join graphof EMPnTITLE PAY is simple.