Consider relations EMP and PAY in Figure 3.3. EMP and PAY are horizontally fragmented as follows: EMP1 = TITLE=Elect.Eng.(EMP) EMP2 = TITLE=Syst.Anal.(EMP) EMP3 = TITLE=Mech.Eng.(EMP) EMP4 = TITLE=Programmer(EMP) PAY1 = SAL30000(PAY) PAY2 = SAL ENO | ENAME | TITLE ENO | PNO | RESP DUR E1 J. Doe Elect. Eng E2 M. Smith Syst. Anal. E3 A. Lee Mech. Eng E4 J. Miller Programmer E3 P3 Consultant E5 B. Casey Syst. Anal. E6 L. Chu Elect. Eng E7 R. Davis Mech. Eng E8 J. Jones Syst. Anal E1 P1 Manager E2 P1Analyst E2 P2Analyst 12 24 10 4 E3 P Engineer E4 P2 Programmer18 E5 P2 Manager E6 P4Manager E7 P3 Engineer E8 P3 Manager 24 48 40 PROJ PAY PNO PNAME BUDGET LOC TITLE P1 Instrumentation150000 MontrealElect P2 Database Develop. 135000 New York Syst. Anal.34000 P3 CAD/CAM P4 Maintenance Eng. 40000 250000 New York Mech. Eng. 27000 Programmer 24000 310000Paris 3.3 Modified Example Database ENO | ENAME | TITLE ENO | PNO | RESP DUR E1 J. Doe Elect. Eng E2 M. Smith Syst. Anal. E3 A. Lee Mech. Eng E4 J. Miller Programmer E3 P3 Consultant E5 B. Casey Syst. Anal. E6 L. Chu Elect. Eng E7 R. Davis Mech. Eng E8 J. Jones Syst. Anal E1 P1 Manager E2 P1Analyst E2 P2Analyst 12 24 10 4 E3 P Engineer E4 P2 Programmer18 E5 P2 Manager E6 P4Manager E7 P3 Engineer E8 P3 Manager 24 48 40 PROJ PAY PNO PNAME BUDGET LOC TITLE P1 Instrumentation150000 MontrealElect P2 Database Develop. 135000 New York Syst. Anal.34000 P3 CAD/CAM P4 Maintenance Eng. 40000 250000 New York Mech. Eng. 27000 Programmer 24000 310000Paris 3.3 Modified Example Database