Textbook Readings and Other Materials
Note: Efforts have been made to provide links to legitimate resources online where available, or to where they can be purchased.
- A First Course in Database Systems (3rd edition) by Ullman and Widom (U/W)
(same material and sections as Database Systems: The Complete Book (2nd edition) by Garcia-Molina, Ullman, and Widom) - Database Management Systems (3rd edition) by Ramakrishnan and Gehrke (R/G)
- Fundamentals of Database Systems (6th edition) by Elmasri and Navathe (E/N)
- Database System Concepts (6th edition) by Silberschatz, Korth, and Sudarshan (S/K/S)
Relational Algebra
Select, project, join
U/W
2.4
R/G
4
E/N
6.1 - 6.3
S/K/S
6.1
Set operators, renaming, notation
U/W
2.4
R/G
4
E/N
6.1 - 6.3
S/K/S
6.1
Relational Design Theory
Relational Design Overview
U/W
---
R/G
---
E/N
15.1
S/K/S
8.1
Functional Dependencies
U/W
3.1 - 3.2
R/G
19.1 - 19.3
E/N
15.2
S/K/S
8.3
Boyce-Codd Normal Form
U/W
3.3
R/G
19.4.1 , 19.6.1
E/N
15.5
S/K/S
8.3.2, 8.5.1
Multivalued dependencies, 4th normal form
U/W
3.5 - 3.6
R/G
19.8.1 - 19.8.2
E/N
15.6
S/K/S
8.6
Shortcomings of BCNF/4NF
U/W
3.4
R/G
---
E/N
---
S/K/S
8.8.4
Unified Modeling Language (UML)
UML Data Modeling
U/W
4.7
R/G
2.7
E/N
10.3
S/K/S
7.9.2
UML To Relations
U/W
4.8
R/G
---
E/N
---
S/K/S
---