SQL and Relational Theory

Errata for SQL and Relational Theory

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed, Safari Books Online
Page 20
Second to last and last lines

The statement '... we might physically store the join of suppliers and shipments, ..., then base relations S and SP could be obtained, conceptually, by taking appropriate projections of that join.' is incorrect. The join of the suppliers and shipments doesn't contain a tuple for the supplier with a SNO of S5, hence S cannot be obtained.

Note from the Author or Editor:
Actually this is p 19 in the printed edition. It was my intention that the words "might" and "conceptually" should alert the reader to be a little careful here (as this reader has been!). But I now see I was being a bit too clever here and should have elaborated further. Yes, this storage scheme will be valid, if applied "mindlessly," only if it can be guaranteed that every supplier does supply at least one part. My apologies.

William Simon  Oct 03, 2013 
Printed
Page 228
Section "Relational Completeness," (lines 5-6).

The "i.e.," should not be split over two lines.

None  Apr 01, 2009 
Printed
Page 310
Fig. C.4

The SUC (suppliers with an unknown city) relation should contain the rows S2, S4 to match the SC relation in Fig C.2 on p. 309.

John Gallagher  Jul 21, 2012 
Printed
Page 398
Index entry for bi-implication

The subentry "SQL, 43" should be moved as a subentry to the index for BOOLEAN.

None  Apr 01, 2009 
Printed
Page 398
Index entry for BOOLEAN

The subentry "vs. truth, 178" should be moved as a subentry to the index entry for consistency.

None  Apr 01, 2009 
Printed
Page 399
Index entry for Faroult

The first name should be Stephane, not Stpehane.

None  Apr 01, 2009 
Printed
Page 400
Index entry for logical difference

The word passim should be in italics.

None  Apr 01, 2009 
Printed
Page 401
Index entry for predicate, subentry for relational expression.

The page numbers should be 122-123.

None  Apr 01, 2009