Lectures
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 |
Topic |
Assigned Reading |
Notes |
1 |
Into to Database Systems Database Applications
|
Chapter 1 |
Part 1
Part 2 |
2 |
The Relational Model SQL - Data Definition Language |
Chapter 3, sections 1 - 3 |
Part 1 Part 2 |
3 |
Relational Algebra |
Chapter 4 (only skim section 3) |
Part 1 & 2 |
4 |
Begin SQL |
Chapter 5 |
2-up
4-up
|
5 |
Finish SQL |
Chapter 5 |
|
6 |
Embedded Sql |
Chapter 6 |
2-up
4-up |
7 |
XML, |
Chapter 27.6-7 |
2-up
4-up |
8 |
Midterm |
|
|
9 |
XPath and XQuery |
|
|
10 |
The Entity-Relationship Model |
Chapter 2 |
2-up
4-up
|
11 |
Database Design |
Chapter 3 section 3.5
|
2-up
4-up
|
12 |
Normalization |
Chapter 19 |
Slightly revised version Nov 27th
2-up
4-up
|
13 |
Finish Normalization, Questions and Review |
|
Some additional lecture notes on BCNF in 2-up and 4-up and .. 2 more useful slides on BCNF (print them for class)
Print out and bring last year's exam to tutorial
|
|