CS 125 -- Database Design
Fall, 2004
Course Schedule
(updated 10/25/2004)

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

2. Sept 6-10
Ch. 3 Relational Model
Project 1
3. Sept 13-17
Relational Model, Ch. 5 Relational Algebra

4. Sept 20-24
Relational Algebra Project 2
5. Sept 27-Oct 1
Ch. 6 SQL
6. Oct 4-8
SQL; 
Project 3
7. Oct 11-15
Monday: no class, Fall Holiday; Friday: Mid-term (through Ch 6, SQL);
8. Oct 18-22
Ch. 7 Constraints and Triggers
9. Oct 25-29
Ch. 8 Embedded SQL Project 4
10. Nov 1-5
Embedded SQL; Ch. 4 Other Data Models
11. Nov 8-12
Other Data Models;
Project 5
12. Nov 15-19
Ch. 9 Object-Orientation in Query Langs; Ch. 4 Semi-structured data, XML

13 Nov 22-26
Ethical issues for databases; Wednesday & Friday: no class, Thanksgiving break
Project 6 (due Monday)
14 Nov 29-Dec 3
Data warehousing and mining; data in the real world; research topics in databases

15 Dec 6-10
Ch. 10 Logical Query Languages; Project demonstrations/presentations
Project 7
16 Dec 13-17
Finals (Wed 12/17 12-2pm, regular location)


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