| Location | Problem | Reported By | Date Reported |
|---|
| p. 106, l. -2
| Only Movies1 was shown to be in BCNF in Example 3.26.
Movies2 is in BCNF because it has no nontrivial FD's.
| Elizabeth Stinson
| 10/23/03
|
| p. 206, l. -11, -1
| subscript t,i should be t,y in both places.
| Philip Minimi
| 2/23/04
|
| p. 244, first paragraph below box
| Actually, = in SQL does not correspond to = in C, but rather to ==.
| Mathew P. Johnson
| 1/12/04
|
| p. 266, l. -13
| NOT s > ALL R → NOT s >= ALL R.
| Krishna Venuturimilli
| 11/2/05
|
| p. 284, l. 5
| Technically, you can have a HAVING clause without a
GROUP-BY clause. In that case, the HAVING applies to
the entire relation as a single group.
| Sudarshan Chawathe
| 9/24/04
|
| p 301, Exercise 6.6.4
| DROP R → DROP TABLE R
| John Manz
| 5/7/03
|
| p. 387, bottom of Fig. 8.18
| Lines 8-10 need to be in a block, so they are only executed when
line 6 does not return an error.
| Mayuk Naik
| 11/4/04
|
| p. 460, l. 9
| ORDER → ORDERING.
| Mayur Naik
| 11/4/04
|
| p. 524, Exercise 11.3.1(b)
| You need to know that the tracks are located on the outer inch of a
3.5-inch-diameter surface.
| Alex Butler and Himanshu Gupta
| 4/24/03
|
| p. 545, footnote
| on l. 2, "fast as first" → "fast at first". On l. 3, "speeds
up" → "slows down".
| Brian Babcock
| 8/26/03
|
| p. 631, Exercise 13.2.3, l. 4
| "averge" → "average"
| David Koller
| 5/20/03
|
| p. 674, l. 4
| "bashed" → "based"
| Waynn Lue
| 7/19/05
|
| p. 725
| All references to 2PMMS should be TPMMS.
| Jeff Pickelman
| 7/15/19
|
| p. 759, l. -5
| "are packed 20 to a block" → "are packed at most 20 to a
block."
| Jian Pei
| 7/21/05
|
| p. 797, l. -2 of box
| The subscript b on the union should be B.
| Jian Pei
| 7/22/05
|
| p. 798, l. 12
| First S should be s.
| Jeff Pickelman
| 7/15/19
|
| p. 825, l. 16-19 of box
| It was pointed out that New York is no longer the second most populous
state; Texas is.
The three most populous states, California, Texas, and New
York, have populations in ratio approximately 1:0.62:0.56, compared with the
ideal of 1:0.71:0.58.
The correspondent also points out that in Germany, the three most
populous states, Nordrhein-Westfalen, Bavaria
and Baden-Wurttemberg, have populations
illustrating the point much better. Their populations are in ratio 1:0.69:0.59.
| Eberhard Bertsch
| 12/16/05
|
| p. 840, l. 7
| The comma after "noticing" should come before "noticing."
| Waynn Lue
| 7/26/05
|
| p. 939, l. -1
| "elements" → "element"
| Matthew F. Dennis
| 12/4/05
|
| p. 978, l. -6
| "part (4)" → "part (d)"
| Mike Wiacek
| 12/6/04
|
| p. 983, 5 lines below the box
| WS(T) → WS(V)
| Qi Su
| 6/2/05
|
| p. 994, l. 20
| Space needed after "Fig."
| Waynn Lue
| 8/6/05
|
| p. 994, title of Fig. 19.3
| "an" → "and"
| David Koller
| 5/13/03
|
| p. 1039, l. -9, -7, -6, and -5; also p. 1040, l. 3
| A5 and A6 are interchanged.
| Simon Frettloeh
| 4/19/07
|
| p. 1011, l. -5.
| The comma at the end should be a period.
| Waynn Lue
| 8/09/05
|
| p. 1047, l.13
| "sofware" → "software"
| Victor Kimeli
| 4/6/03
|
| p. 1053, l. -6
| Period after "warehouses" should be a comma.
| Waynn Lue
| 8/9/05
|
