Errata


Print Print Icon

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.


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



Version Location Description Submitted By
Printed Page 29
middle of the page

WHERE NOT EXISTS
( SELECT *
FROM SP
WHERE SP.PNO = S.SNO )

should be

WHERE NOT EXISTS
( SELECT *
FROM S, SP
WHERE SP.PNO = S.SNO )

Anonymous 
Printed Page 46
2nd paragraph on the page

In the book 'SQL and Relational Theory, 1st Edition', in section '2.8.
Collations in SQL', the third paragraph has been added in error.
(it's actually the 2nd paragraph on page 46)

Anonymous 
Printed Page 78
4th paragraph - just one example. The web form forced a single page number.

The tiny asterisks for indicating the reference point in the text for footnotes were hard for my 60 year old eyes to pick up. The daggers for a second foot notes were clear. I've been using a yellow highlighter to mark the asterisks. Many of the notes make little sense unless placed in context by the text reference.

The book is fine: useful and informative.

Lloyd Kvam 
Printed Page 345
Solution to Exercise 6.9.h)

The SQL-query returns a wrong result in the border case that there is no supplier located in London and there is a product without shipment (both at the same time). The SELECT DISTINCT should be just a SELECT from the table P.

 
Printed Page 348
Solution to Exercise 7.1.b)

Solution does not match exercise (roles of S and P were switched in exercise b) in comparison to exercise a), but NOT in the solution)

 
Printed Page 387
Last paragraph

The answer to the exercise B-24-b (page 312) is "False" and not "True" as stated in the ANSWERS TO EXERCISES section (page 387).

Anonymous 
Printed Page 394
lines 1 and 2

A closing parenthesis and the word "as" need to be added to the following sentence: "called object/relational features (see reference [28])), but they're mostly irrelevant as far as the goal of using SQL relationally is concerned."

Anonymous 
Printed Page 399
Entry for Faroult, Stéphane

The entry should read "Faroult, Stéphane" NOT "Faroult, Stpéhane".

Anonymous 


"...the book is a recommended read for all the database practitioners and other related professionals looking to match their implementations with the theoretical concepts and hence improving usability of the relational database model implemented within the enterprise."
--Ganadeva Bandyopadhyay, Desicritics.org