Errata

changed the equation on line 3 to read:

(16,000,000 - 10,000) * 50 = 799 million characters

plus, in the next para., changed "megabytes" to "gigabytes"

"1.6 gigabytes"

longer a superkey"

{ISBN, PubPhone} and {PubPhone, PubName}
to

{ISBN, PageCount} and {PageCount, Price}

referred to in the text - very minor detail, but labeling the tables
would increase reader-friendliness.

greater-than-or-equal-to sign to a regular greater-than sign

right-hand cells changed to "j"

cell changed to "j"

(sel S.A2 = T.A2, S.A4 = T.A4(SxT))

to:

(sel S.A1 = T.A1(SxT))

code sample 3 now reads:

CREATE TABLE BOOKS2
(ISBN TEXT(13) CONSTRAINT PrimaryKeyName PRIMARY KEY,
TITLE TEXT(100),
PRICE MONEY,
PubID TEXT(10), CONSTRAINT Test FOREIGN KEY (PubID) REFERENCES Publishers
(PubID));

"This is, in fact, the semi-join"
to

"This is, in fact, a projection of the semi-join"

of the last line; also, changed the first line of that code example to
read:

SELECT PUBLISHERS.PubName, MIN(Price) AS [Minimum Price]

Set dbLibrary = ws.OpenDatabase("d:daolibrary.mdb")
to

Set dbLibrary = DBEngine.OpenDatabase("d:daolibrary.mdb")

intGrade = Val(InputBox("Enter student's average _ test score: "))

to

intGrade = Val(InputBox("Enter student's average test score: "))

intvar = 123

It goes after the current second line.

connected. And Containers should also be connected to the horizontal
line immediately above it (that originates from Databases).

"of the previous example, we could have written"
to

"we can write"

Running the code in Exaple 9-6 produces the message box
shown in Fiure 9-8,
to
Running the code in Exaple 9-6 produces two message boxes;
the second is shown in Fiure 9-8,

strSQL = "UPDATE BOOKS SET Price = Price*1.1 WHERE Price > 20"

to

strSQL = "UPDATE BOOKS SET Price = Price*1.1"

If qdf.RecordsAffected > 15 Then

to

If qdf.RecordsAffected <= 15 Then

they appear as follows:

MsgBox qdf.RecordsAffected & _
" records affected by this query. Transaction cancelled."

Msgbox rsTable!Title

with the two lines

If Left$(tsTable!Title,2) = "On" then
Msgbox rsTable!Title

1. Changed the last cell in the last row to "red oak"
2. Added another row with first cell "Fred's Woods" and second cell
"poplar."
3. Added another row with first cell "Fred's Woods" and second cell
"mahogany."