next up previous
Next: Chapter 9 Up: Errata for ``Principles of Previous: Chapter 7

Chapter 8

Page 204:
On line 1, close the parentheses after 7.3.
Page 206:
In Example 8.3, delete the following part of the sentence from the query specification: ``and their manager's name''. The query doesn't retrieve manager's name.
Page 208:
In Figure 8.2, there should be a loop from ASG to ASG labelled ``DUR $ \geq$ 36''. The label is there, but not the loop. There should also be a loop from EMP to EMP labelled ``TITLE = ``Programmer''. Again the label is there, but not the loop.
Page 214:
In Figure 8.5, all of JNO's should be PNO and the single JNAME should be PNAME. These are again left-overs from first edition.
Page 215 and later:
On this page, line 5 of the second paragraph defines generic query. This term should be changed to localized query. This change should be propagated to the following places:
Page 219:
In Figure 8.8, $ E_1$ and $ E_2$ should be $ EMP_1$ and $ EMP_2$, respectively.
Page 224:
Third line in Section 8.4 has ``citerh80''. This error is caused by forgetting the backslash before ``cite''. It should be a reference to [Rosenkrantz and Hunt, 1980], which is already in the references.
Page 225:
Exercise 8.2 should have one more predicate in the WHERE clause: AND PROJ.PNO = ASG.PNO.
Page 226:
Exercise 8.5 should have one more predicate in the where clause: AND (DUR>24 OR PNAME=``CAD/CAM''). Also, the last sentence of the question should be revised replacing the part ``... a form that is optimal ...'' with ``three equivalent forms.'' Thus the sentence should read: ``Furthermore, compose and operator tree corresponding to the query and transform it, using relational algebra transformation rules, to three equivalent forms.''

next up previous
Next: Chapter 9 Up: Errata for ``Principles of Previous: Chapter 7
M. Tamer Ozsu
2001-01-12