Errata for Database Systems: The Complete Book
    Also check the Previous Errata Sheet. if you have the first or second printing of either Database Systems: The Complete Book or A First Course in Database Systems (2nd Edition).

    LocationProblemReported ByDate 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 RNOT 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 RDROP 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 ORDERORDERING. 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

    Also, thanks to Yunfan Bao, Alissa Cooper, Matthew F. Dennis, Mark Gjol, Himanshu Gupta, Brian Jorgensen, Andrea Knaut, Younghan Lee, Soren Peen, and Bing Yu for pointing out errors in the book's Web pages.