Database Design and Relational Theory

Index

For alphabetization purposes, (a) differences in fonts and case are ignored; (b) quotation marks are ignored; (c) other punctuation symbols—hyphens, underscores, parentheses, etc.—are treated as blanks; (d) numerals precede letters; (e) blanks precede everything else.

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

(3,3)NF, “Restriction-union” normal form

(JD star), JDs and 5NF (Informal)

0-tuple, CHAPTER 2, CHAPTER 4

2NF, see second normal form, ... AND STILL ANOTHER

3NF procedure, A PROCEDURE THAT WORKS

3NF, see third normal form, ... AND STILL ANOTHER

5NF, see fifth normal form, PREDICATES AND PROPOSITIONS

6NF, see sixth normal form, PREDICATES AND PROPOSITIONS

“arrow out of X”, FUNCTIONAL DEPENDENCIES

“atomic fact,” 142, SIXTH NORMAL FORM

“getting rid of” (constraints), BOYCE/CODD NORMAL FORM

“materialized view,” 175, We Need More Science

“restriction-union” normal form, Elementary key normal form (EKNF)

“well architected,” 241, CHAPTER 8

→ (FD arrow), MORE ON SUPPLIERS AND PARTS

A

Abbey, Edward, PREDICATES AND PROPOSITIONS

Abbot, Bud, MVDs and 4NF

Abiteboul, Serge, THE CHASE ALGORITHM

Adamson, Chris, Logical vs. Physical Design, WHAT DENORMALIZATION ISN’T (I)

Adiba, Michel, 2. Declare the Constraint ...