Start any video training course for FREE. More than 500 to choose from. Learn more
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 
Page 228
Section "Relational Completeness," (lines 5-6).

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

scottd_oreilly  Apr 01, 2009 
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 
Page 398
Index entry for bi-implication

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

scottd_oreilly  Apr 01, 2009 
Page 398
Index entry for BOOLEAN

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

scottd_oreilly  Apr 01, 2009 
Page 399
Index entry for Faroult

The first name should be Stephane, not Stpehane.

scottd_oreilly  Apr 01, 2009 
Page 400
Index entry for logical difference

The word passim should be in italics.

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

The page numbers should be 122-123.

scottd_oreilly  Apr 01, 2009