CMPUT 291 Schedule
| Week | Month | Date | Lectures | Readings ( Chapters ) |
Labs |
|---|---|---|---|---|---|
| 1 | Jan | 9 | Introduction | 1 | |
| 2 | 11 16 | ER Model | 4 | ||
| 3 | 18 23 | Relational Model | 3 |
ER Model
(pdf) scenario Dia | |
| 4 | 25 30 | Relational Algebra | 5 | SQL*Plus (pdf) tutorial | |
| 5 6 | Feb | 1, 6,8 13,5 | SQL | 5 |
Relational algebra & SQL expressions
(pdf) Lab Quiz 1 SQL |
| 7 | | Reading Week | |||
| 8 | 27 | Midterm Exam |
JDBC
(pdf)
tutorial 1 | ||
| March | 1 | Database Application | 8 | ||
| 9 | 6,8 | Database Design | 6 |
JDBC 2: the resultset(pdf)
tutorial 2 | |
| 10 | 13,15 | Index and File Organization | 9 |
Lab Quiz 2 JDBC | |
| 11 12 | 20,22, 27 | B-tree | 9 |
Berkeley DB (pdf) | |
| 13 | April | 29 3 | Hash Table | 9 | |
| | 5 | Database Tuning | 12 | ||
| 14 | 10 | Transactions | 18 | ||
| 12 | Review |
|
