Notes
| Sep 1 | Tue | Introduction to the class
| 1
|
[intro-pptx]
[intro-HTML]
|
| Sep 3 | Thu | Entity-relationship Model
| 6 (except 6.11)
|
[ER-Relational-pptx]
[ER-Relational-pdf]
|
| Sep 8 | Tue | ER Model; Relational Model
| 6 (except 6.11), 2
|
|
| Sep 10 | Thu | Converting ER to Relational
| 6 (except 6.11), 2
|
|
| Sep 15 | Tue | SQL
| 2, 3 (except 3.11), 4.2, 8.6
| [SQL-RA-pptx] [SQL-RA-pdf] Movies DB Queries
|
| Sep 17 | Thu | Relational Algebra; SQL
| (continued)
|
|
| Sep 22 | Tue | SQL
| (continued)
|
|
| Sep 24 | Thu | SQL
| (continued)
|
|
| Sep 29 | Tue | SQL
| Chapter 7
|
|
| Oct 1 | Thu | Integrity Constraints; Normalization
| Chapter 7
| [Normalization-pptx] [Normalization-pdf]
|
| Oct 6 | Tue | Normalization
| Chapter 7
|
|
| Oct 8 | Thu | Midterm 1
|
|
|
| Oct 13 | Tue | Normalization
| Chapter 7 |
|
| Oct 15 | Thu | Normalization; Storage: Files
| Chapter 4, 8
|
|
| Oct 20 | Tue | Storage: Files
| Chapter 11
| [Storage-pptx] [Storage-pdf]
|
| Oct 22 | Thu | Storage: Indexing/Hashing
| Chapter 12, except 12.4, 12.9.
|
|
| Oct 27 | Tue | Storage: Indexing/Hashing
|
|
|
| Oct 29 | Thu | Storage; Query Processing;
| Chapter 13.
| [Query-Proc.-pptx] [Query-Proc.-pdf]
|
| Nov 3 | Tue | Query processing; Join algorithms; Sorting
|
|
|
| Nov 5 | Thu | Query processing
|
|
|
| Nov 10 | Tue | Midterm 2
| |
|
| Nov 12 | Thu | Query optimization
| Chapter 14, except 14.5
| [Query-Opt-pptx] [Query-Opt-pdf]
|
| Nov 17 | Tue | Query optimization
| |
|
| Nov 19 | Thu | Query optimization
| |
|
| Nov 24 | Tue | Query optimization
|
|
|
| Nov 26 | Thu | Thanksgiving
| |
|
| Dec 1 | Tue | Transactions; Concurrency
| Chapter 15; Chapter 17, except 17.8, 17.9. | [ACID-pptx] [ACID-pdf]
|
| Dec 3 | Thu | Recovery
| |
|
| Dec 8 | Tue |
Recovery;
|
|
|
| Dec 10 | Thu |
Miscellaneous Topics; Wrapup |
|
|
| Dec 18 | Friday | FINAL (Mon 1:30pm - 3:30pm)
|
|
|