Chapter 9

Page 240:

In query $q''$, the WHERE predicate should read $P_2(R_{1}.A_{1}, \ldots, R_{n}.A_{n})$.

Page 243:

On line 16, replace $V$ with $R$.

Page 248:

In Example 9.6, the join order should be PROJ $\Join_{\rm PNO}$ ASG $\Join_{\rm ENO}$ EMP.

Page 268:

In Figure 9.14, in the lower table, $R_{3}.B$ should be $R_{2}.B$ and $R_{4}.B$ should be $R_{3}.B$. In the second iteration, $SJ_2$ should have cost 80, not 200 (this is on line 6 from the bottom).