| Date |
Content covered |
Reading |
|
08/25/09 |
Syllabus, Introduction [Notes: ] |
Chapter 1 |
|
08/27/09 |
Basics of databases [slides:
][Notes:] |
Chapter 1 |
|
09/01/09 |
Relational databases [Notes:] |
Chapter 2 |
|
09/03/09 |
Query languages, relational algebra [Notes:] |
Chapter 2 |
|
09/08/09 |
Relational algebra [Notes:] |
Chapter 2 |
|
09/10/09 |
Relational algebra [Notes: ] |
Chapter 2 |
|
09/15/09 |
Relational calculus, writing queries in
R.A. [Notes:
] |
Chapter 2 |
|
09/17/09 |
More R. A. exercises [Notes:] |
Chapter 2 |
|
09/22/09 |
SQL [Notes:Sample
database schemas: ] |
Chapter 3 |
|
09/24/09 |
More SQL [Notes: ] |
Chapter 3 |
|
09/29/09 |
Nested queries in SQL [Notes: The VIP
example:] |
Chapter 3 |
|
10/08/09 |
Midterm (in-class) |
Chapter 3 |
|
10/13/09 |
Views, procedural extensions to SQL [Notes:
]
sample PL/SQL functions/procedures:
 |
Chapter 4 |
|
10/15/09 |
Database design: ER
modeling [Notes: ] |
Chapter 6 |
|
10/20/09 |
Database design: mapping
ER to relations [Notes: ] |
Chapter 7 |
|
10/22/09 |
Database design:
functional dependencies [Notes:
] |
Chapter 7 |
|
10/27/09 |
Database design:
normalization [Notes:] |
Chapter 7 |
|
10/29/09 |
Application development
[Notes: ,
Sample JDBC code
] |
Chapter 8 |
|
11/03/09 |
Storage and file
structure [Notes:] |
Chapter 11 |
|
11/05/09 |
File
structure [Notes:] |
Chapter 11 |
|
11/10/09 |
File structure, indexing
[Notes:] |
Chapter 11, 12 |
|
11/12/09 |
Indexing: ISAM and
B+-trees[Notes:] |
Chapter 12 |
|
11/17/09 |
B+-trees: insertion and deletion[Notes: ] |
Chapter 12 |
|
11/19/09 |
B+-trees exercises and query evaluation [Notes:] |
Chapter 12, 13 |
|
11/24/09 |
Query processing and optimization [Notes:] |
Chapter 13 |
|
12/01/09 |
Query processing and optimization, Final review [Notes: Old exam: Solution: ] |
|
| 12/03/2009 |
Project 4 demo |
|
| 12/10/2009 |
Final exam, 5:30pm - 7:30pm, ENC1002 |
|
]
]
]