11ecbd6c_0926_3853_b1d8_a54c2b416ce4_SM8842_00 Figure 14.5 11ecbd6c_3745_0364_b1d8_5b80c62634f2_SM8842_00 Figure 14.6 -Why do spurious tuples occur in the result of joining the EMP_PROJ1 and EMPLOCS relations of Figure 14.5 (result shown in Figure 14.6)?

Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

Edition 6ISBN: 0136086209

Edition 6ISBN: 0136086209

Exercise 9

Figure 14.5

Figure 14.6
-Why do spurious tuples occur in the result of joining the EMP_PROJ1 and EMPLOCS relations of Figure 14.5 (result shown in Figure 14.6)?

Explanation

Verified

In EMP_LOCS, a tuple (e, l) signifies th...