Errata for Principles of Database Systems

Errata Sheet for

Principles of Database Systems with Internet and Java Applications

by Greg Riccardi

ISBN 0-201-61247-X

Comments are in italic and modified text is in blue.

P. iv, line 1should be: Senior Acquisitions Editor: Maite Suarez-Rivas

P. xx, paragraph 4, line 1, email address of Greg Riccardi should be: riccardi@acm.org

P. 143, line –2, the join attribute should be: purchaseOrderId

P. 170, Problem 12b should be:

c. Write insert statements to add entities to the database of Problem 12.b.

P. 213, Last line of the table at the bottom of the page, each ‘&’ should be ‘%’

Encoding

104+x%2B%26+%3C%2F.

%2B

%26

%3c

%2F

P. 327, Table 13.1, Rental entry should be:

Rental	10,000	100	100	accountId	B+ tree	100	2
				movieId	B+ tree	100	2
				date	B+ tree	100	2

P. 344, Figure 13.10a. The line above Movie at the bottom of the graph should connect to the projection operator.

P. 382, Problem 15, third line should add the text “of the same actions” as below.

teristics, list a different schedule of the same actions that does.

P. 476, Paragraph 3, lines 5, 6, and 7. The four references to Employee should be to Customer. Correct paragraph is:

An array of int, or of any other primitive type, is represented by a block of memory containing space for the required number of values. An array whose elements are objects is represented by an array of object references. When an array object is created, as in line 8 of Fig. A.5, each array elements is null. This array of Customer is really an array of Customer references, initially all null. The assignment of a new Customer object to element 0 in line 9 allows line 10 to modify a field of the referenced Customer object.

P. 485, Figure A.10, line 6 should be indented 2 spaces. Correct code is:

1 public class DemoException {

2 public void demo() {

3 String str = null;

4 int len;

5 try { // beginning of try statement

6 len = str.length(); // null reference exception occurs

7 } catch (NullPointerException e) {// catch statement

8 len = 0; // executed if exception thrown in try block

9 }

10 }

11 }

P. 518, In the third line, add p. 225 to the list of references for Encoding, as below:

Encoding 213–214, 225, 232