Errata

The correct edit for the previous errata I just submitted may actually be to replace:

"2. U2: Extracting Elements"

with:

"2. U2: Extracting Element"

to match the text in the 1-U2 box in the upper gray section of Figure 1-1 on p. 4.

Note from the Author or Editor:
Confirmed.

In the 4th-to-last row of Table 2-4, the character before the first "3" needs to be changed to "1" (the character before the first "3" is either an upper-case "I" [pronounced "eye"] or a lower-case "l" [pronounced "ell"]).

Note from the Author or Editor:
Confirmed.

In the last sentence of the 2nd-to-last paragraph, I believe that "remains" needs to be replaced with "remain" in the following sentence: "What does remains something of a paradox is whether a correct theoretical foundation for mathematics exists." The corrected sentence reads as follows: "What does remain something of a paradox is whether a correct theoretical foundation for mathematics exists." Alternatively, remove the word "does" from the original sentence: "What remains something of a paradox is whether a correct theoretical foundation for mathematics exists."

Note from the Author or Editor:
Confirmed.

In the 1st sentence in 1st paragraph under "The Keyword IF in Control-of-Flow Statements", I believe "set based" should be replaced with "set-based" in the following:

"Although the focus of this book is T-SQL's query language, and SQL's central (or at least most interesting) paradigm is set based, "regular" programming based on decision and repetition is also implemented."

Note from the Author or Editor:
Confirmed..

In the 3rd-to-last line on the page, the word "are" needs to be inserted in between "There" and "are" in the following sentence:

"There a number of alternatives and generalizations to predicate logic."

The corrected sentence reads as follows:

"There are a number of alternatives and generalizations to predicate logic."

Note from the Author or Editor:
Confirmed.

The 6th sentence in the 2nd paragraph under the heading "Naming Conventions":

"However, if the table and the columns would be named Table1(column1, column2, column3, column4)."

does not appear to be a complete sentence.

Replacing "However" with "Not so" would "make it work" (i.e., flow) with the previous sentence.

I also recommend inserting a blank space after "Table1".

The resultant sentence reads as follows:

"Not so, if the table and the columns would be named Table1 (column1, column2, column3, column4)."

Note from the Author or Editor:
Confirmed. Only the page number where this sentence appears is 89, not 86.

In the 2nd-to-last sentence in the 2nd paragraph under the ?Relational Algebra? heading:

"Of course, because the collection of relational operators is open ended, my list is not complete."

?open ended? should be replaced with ?open-ended?

Note from the Author or Editor:
Confirmed.

In the 3rd full sentence on the page:

"Such an operator is not a part of Codd's original algebra, so I will introduce after this section that deals with the original eight operators."

I believe the word ?it? should be inserted in between ?introduce? and ?after?

The corrected sentence reads as follows:

?Such an operator is not a part of Codd?s original algebra, so I will introduce it after this section that deals with the original eight operators.?

Note from the Author or Editor:
Confirmed.

In the last sentence of the first paragraph under Figure 3-9:

"Although this book does not deal with temporal problems, many books do, such as Inside Microsoft SQL Server 2008: T-SQL Programming by Itzik Ben-gan et al. (Microsoft Press, 2009)."

"Ben-gan" should be replaced with "Ben-gan," (insert a comma [","] immediately after "Ben-gan").

Note from the Author or Editor:
Also, last name should be spelled as Ben-Gan

In the 3rd sentence in the 1st full paragraph:

"The details of constraints are quite system specific, and it seems more appropriate to switch to the system that this book is about - namely, Microsoft SQL Server 2008."

please replace "system specific" with "system-specific".

The corrected sentence reads as follows:

"The details of constraints are quite system-specific, and it seems more appropriate to switch to the system that this book is about - namely, Microsoft SQL Server 2008."

Note from the Author or Editor:
Confirmed.

In the last sentence in the 1st paragraph:

"Figure 3-14 shows a denormalized version of the invoices database."

please capitalize the "i" at the beginning of "invoices".

Here is the corrected sentence:

"Figure 3-14 shows a denormalized version of the Invoices database."

Note from the Author or Editor:
Confirmed.