Schedule
The lecture notes will be posted below in PDF format.
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 ER Model
|
Chapter 1: 1.1, 1.2, 1.3, 1.4, 1.5, 1.6
Chapter 2: 2.1, 2.2, 2.3, 2.4, 2.5 |
Into to Database Systems
The ER Model
|
| 2 |
Jan 14 |
|
ER Model Cont'
|
Chapter 2: 2.1, 2.2, 2.3, 2.4, 2.5 |
ER Model Cont'
|
| 3 |
Jan 21 |
|
Relational Model
Database Design
|
Chapter 3: 3.1, 3.2, 3.5 |
Relational Model
Database Design
|
| 4 |
Jan 28 |
|
Normal Forms
|
Ch19: 19.1, 19.2, 19.3, 19.4 |
Normal
Forms
|
| 5 |
Feb 4 |
|
Normal Forms, cont' |
Ch19: 19.4 19.5, 19.6, 19.7 |
|
| 6 |
Feb 11 |
Assignemnt 1 due |
Relational Algebra |
Ch4: 4.1, 4.2 |
Relational Algebra |
|
| 7 |
Feb 18 |
|
Reading Week |
| 8 |
Feb 25 |
|
SQL DDL
SQL
|
|
SQL DDL
SQL
|
| 9 |
Mar 4 |
|
Midterm |
|
|
| 10 |
Mar 11 |
|
SQL cont' |
|
SQL cont' |
| 11 |
Mar 17 |
|
Embedded SQL
|
|
Embedded SQL
|
| 12 |
Mar 24 |
|
Querry Processing |
|
Querry Processing
|
| 13 |
Mar 31 |
|
XML |
|
XML |
|