Schedule
The lecture notes will be posted below in PDF format.
Some parts of the notes will be left blank for you to complete in class.
In addition to these notes, we will spend time during lectures to work through relevant examples
(which will not be posted.)
All readings, tutorials, and class material will be considered for the midterm and final exam.
Week |
Term
work |
Topic |
Assigned Reading |
Notes |
# |
Starts |
1 |
Jan 7 |
|
Into to Database Systems
The Relational Model
|
Chapter 1
Chapter 3, section 1 |
2-up, 4-up
2-up, 4-up |
2 |
Jan 14 |
|
SQL - Data Definition Language
Relational Algebra |
Chapter 3, sections 2 - 3
Chapter 4 (only skim section 3) |
2-up, 4-up
2-up, 4-up |
3 |
Jan 21 |
|
Begin SQL |
Chapter 5 |
2-up, 4-up |
4 |
Jan 28 |
Assignment 1
due |
Finish SQL |
Chapter 5 |
|
5 |
Feb 4 |
|
Embedded Sql
- JDBC (St. George)
The Entity-Relationship Model (UTSC) |
Chapter 6 (for St. George)
Chapter 2 (for UTSC) |
2-up, 4-up
2-up (fonts fixed), 4-up (fonts fixed)
2-up, 4-up
|
6 |
Feb 11 |
Assignment 2
due |
The Entity-Relationship Model (St. George)
Embedded SQL - JDBC (UTSC) |
Chapter 2 (for St. George)
Chapter 6 (for UTSC) |
2-up,
4-up
2-up,
4-up
|
|
7 |
Feb 18 |
|
Reading Week |
8 |
Feb 25 |
|
Midterm |
9 |
Mar 3 |
Assignment 3
due |
Finishing ER Model
|
Chapter 2
|
ER Part 2: 2-up,
ER Part 2: 4-up
|
10 |
Mar 10 |
|
Database Design |
Chapter 3 section 3.5 |
UTSC 2-up, UTSC 4-up
StG 2-up,
StG 4-up
|
11 |
Mar 17 |
|
Normalization |
Chapter 19 |
2-up (updated March 18),
4-up (updated March 18)
|
12 |
Mar 24 |
Assignment 4
due |
Query Processing |
|
2-up, 4-up |
13 |
Mar 31 |
|
OLAP and Data Warehousing |
(Last lecture for UTSC) |
2-up, 4-up |
14 |
Apr 7 |
|
In-Class Final for St. George Campus |
|
|
|