CS 125 -- Database Design
Fall, 2006
Course Schedule
(updated 11/18/2006)

Course Week
and lecture slides*
Topics Assignments
1. Aug 28-Sept 1
Ch. 1 Introduction; Ch. 2 Entity-Relationship Model, Weak Entity sets, Entity-Relationship Design

2. Sept 4-8
Ch. 3 Relational Model
Project 1
3. Sept 11-15
Relational Model, Ch. 5 Relational Algebra

4. Sept 18-22
Relational Algebra
5. Sept 25-29
Ch. 6 SQL Project 2
6. Oct 2-6
SQL; 

7. Oct 9-13
Monday: no class, Fall Holiday; Friday: Mid-term (through Ch 6, SQL);
8. Oct 16-20
Ch. 7 Constraints and Triggers Project 3
9. Oct 23-27
Ch. 8 Embedded SQL
10. Oct 30-Nov 3
Embedded SQL; Ch. 4 Other Data Models Project 4 (due Monday Nov 6)
11. Nov 6-10
Other Data Models;

12. Nov 13-17
Ch. 9 Object-Orientation in Query Langs; Ch. 4 Semi-structured data, XML

13 Nov 20-24
Ethical issues for databases; Wednesday & Friday: no class, Thanksgiving break

14 Nov 27-Dec 1
Data warehousing and mining; data in the real world; research topics in databases
Project 5 (due Wed. Nov 29)
15 Dec 4-8
Project demonstrations/presentations
Project 6 (due Wed. Dec 6)
16 Dec 11-15
Finals


*  Slides are derived from Professor Ullman's powerpoint slides available at the text site given on the front page.