Lectures
Below are the required readings and lecture notes for each topic in the course. The required text is Ramakrishnan et al, but we offer alternative readings in Silbershatz et al for those who may already have access to that textbook.
Lecture notes will be posted below as they become available. A lot happens in lecture that will not be represented in these notes, so if you miss class, it would be a good idea to talk to someone who was there.
You are responsible for all readings and all material covered in lecture and tutorial; any of it may appear on the tests or the final exam.
| Topic |
Readings (Silbershatz et al) |
Alternative Readings (Ramakrishana et al) |
Notes (day section: Truta) |
Notes (evening section: Horton) |
|---|---|---|---|---|
| Introduction | Chapter 1 | Chapter 1 | Truta's notes | Introduction |
| The Relational Model | Section 2.1 | Section 3.1 | Truta's notes | Relational Model |
| Relational Algebra | Sections 2.2 and 2.3 | Sections 4.1, 4.2, and 4.4 |
Relational
Algebra, part 1 Relational Algebra, part 2 |
|
|
SQL: Data Definition Language and SQL: Data Manipulation Language |
Chapter 3; Sections 4.1, 4.2, 4,4 and 4.5 |
Sections 3.2 to 3.5, 3.6.1, and 3.7; Chapter 5 |
SQL: DDL | |
| SQL in a program and JDBC | S Readings TBA | R Readings TBA | ||
| XQuery | Sections 10.1 to 10.4 | Sections 7.3, 7.4.1, and 7.4.2 Sections 27.6, 27.7.1, 27.7.2 | ||
| The Entity-Relationship Model | Sections 6.1 to 6.1 | Sections 2.1 to 2.6 | ||
| Database Design and Normaliztion | Sections 7.1 to 7.5, and 7.8 | Sections 19.1 to 19.7 | ||
| There may be additional topics, if we have time |
Here is the tentative schedule of topics for each week of the course. Some topics may shift around depending on how we progress.
| Week | Topics | Horton's announcements |
|---|---|---|
| 1 |
Introduction The Relational Model |
|
| 2 | Relational Algebra | week 2 announcements |
| 3 | Relational Algebra continued | week 3 announcements. |
| 4 | SQL | week 4 announcements. |
| 5 | SQL continued | |
| 6 | SQL continued | |
| 7 |
SQL in a program and JDBC XQuery |
|
| 8 | XQuery continued | |
| 9 |
XQuery continued Entity-Relationship Model and Database Design |
|
| 10 |
Entity-Relationship Model and Database Design continued Normalization |
|
| 11 | Normalization continued | |
| 12 | TBD | |
| 13 | TBD |