Errata

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
Printed,	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.	scottd_oreilly	Apr 01, 2009
Printed	Page 230 end of 1st paragraph	The Lincoln quote says "You can fool some of the people some of the time, and some of the people all the time, but you cannot fool all the people all of the time." Shouldn't it be: "You can fool all the people some of the time, and some of the people all the time, but you cannot fool all the people all the time." (e.g. https://en.wikiquote.org/wiki/Talk:Abraham_Lincoln#Fool_some_of_the_people) Note from the Author or Editor: Actually this quote is given in different forms in different places. Some references even attribute it to someone other than Lincoln! But I agree that the form suggested is slightly better than the one the book currently gives. Note that this same point also applies to the 2nd and 3rd editions of the book.	Greg Gaughan	Apr 06, 2016
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.	scottd_oreilly	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.	scottd_oreilly	Apr 01, 2009
Printed	Page 399 Index entry for Faroult	The first name should be Stephane, not Stpehane.	scottd_oreilly	Apr 01, 2009
Printed	Page 400 Index entry for logical difference	The word passim should be in italics.	scottd_oreilly	Apr 01, 2009
Printed	Page 401 Index entry for predicate, subentry for relational expression.	The page numbers should be 122-123.	scottd_oreilly	Apr 01, 2009