EMP table is given below:

ENO,ENAME,TITLE

E$1,$J$.$ Doe,Elect. Eng Syst$.$ Anal.

E$2,$M$.$ Smith,Mech. Eng.

E$3,$A$.$ Lee,Programmer Syst$.$ Anal.

E$4,$J$.$ Miller,Elect. Eng.

E$5,$B$.$ Casey,Mech, Eng.

E$6,$L$.$ Chu,Syst$.$ Anal.

E$7,$R$.$ Davis,

EB$,$J$.$ Jones,

ASG table given below:

ENO,PNO,RESP,DUR

E$1,$P$1,$Manager,$12$

E$2,$P$1,$Analyst,$24$

E$2,$P$2,$Analyst,$6$

E$3,$P$3,$Consultant,$10$

E$3,$P$4,$Engineer,$48$

E$4,$P$2,$Programmer,$18$

E$5,$P$2,$Manager,$24$

E$7,$P$3,$Engineer,$36$

E$8,$P$3,$Manager,$40$

PROJ table given below:

ENO,PNO,RESP,DUR

E$1,$P$1,$Manager,$12$

E$2,$P$1,$Analyst,$24$

E$2,$P$2,$Analyst,$6$

E$3,$P$3,$Consultant,$10$

E$3,$P$4,$Engineer,$48$

E$4,$P$2,$Programmer,$18$

E$5,$P$2,$Manager,$24$

E$7,$P$3,$Engineer,$36$

E$8,$P$3,$Manager,$40$

PAY table given below:

PNO,PNAME,BUDGET,LOC

P$1,$Instrumentation,$150000,$Montreal

P$2,$Database Develop.,$135000,$New York

P$3,$CADICAM,$250000,$New York

P$4,$Maintenance,$310000,$Paris

Consider relations EMP and PAY in Fig$\mathrm{.}2$ EMP and PAY are horizontally fragmented as follows:

EMP$1=$ Select$($TITTLE$)=$ "Elect.Eng."$($EMP$)$

EMP$2=$ Select$($TITTLE$)="$Syst$.$Anal."$($EMP$)$

EMP$3=$ Select$($TITTLE$)=$ "Mech.Eng."$($EMP$)$

EMP$4=$ Select$($TITTLE$)=$ "Programmer"$($EMP$)$

PAY$1=$ Select$($SAL$)>=30000($PAY$)$

PAY$2=$ Select$($SAL$)<30000($PAY$)$

a$.$ Draw the join graph of EMP join on Tittle PAY

b$.$ Suggest a modified partitioning of either EMP or PAY to simplify the join graph.

c$.$ Using the fragmentation of PAY, perform further derived horizontal fragmentation for EMP.

give me answer in simple and better explaination along join graph