Errata

Writing a book is like writing software -- there are always some bugs. Please accept my apologies for any errors and omissions.

If you find errors or have suggested changes, please contact me.

Legend

	Error
	Improvement

p. 82 (Aug 31, 2005)

Exercise 4. String comparisons are not case sensitive in MySQL, but this is not the case in other implementations of the relational model.

p. 90 (Mar 22, 2007)

Figure 4-1 shows the 1:m relationship between NATION and STOCK.

p. 122 (Nov 7, 2007)

If a universal quantifier were supported by SQL, this query could be phrased as, “Select item names where forall sales there exists a lineitem row recording that this item was sold.” A quick inspection of Table?5-1 shows that one item satisfies this condition (itemno = 2).

While SQL does not directly support the universal quantifier, formal logic shows that forall can be expressed using exists. The query becomes, “Find items such that there does not exist a sale in which this item does not appear.” The equivalent SQL expression is

p. 144 (Mar 22, 2007)

Edward VIII in third row.

p. 163 (Mar 22, 2007)

Figure 7-7 should be

p. 165 (Oct 8, 2005)

Figure 7-9 should be

See skillbuilder.

p. 177 (Oct 9, 2006)

Figure 7-27 should be Figure 7-28

p. 208 (Mar 22, 2007) - two errors

PRIMARY KEY(firmname));

p. 209 (Sep 1

8, 2005)

Figure R-11 should be (+ sign is deleted)