CS 125 -- Database Design
Fall, 2003
Course Schedule
(updated 1/26/2004)

Course Week
and lecture slides*
Topics Assignments
1. Sept 1-5
Ch. 1 Introduction; Ch. 2 Entity-Relationship Model, Weak Entity sets, Entity-Relationship Design
Project 0
2. Sept 8-12
Ch. 3 Relational Model
Ch 2: .1.1, .1.3, .1.6, .1.7, .2.1, .2.3, .2.6, .3.1, .3.2, .3.4, .4.1, .4.2, 4.4; Project 1
3. Sept 15-19
Relational Model, Ch. 6 SQL
Ch 3: .1.2, .2.1, .2.2, .2.3, .2.4a, .3.1, .3.2, .3.4, .4.1, .4.2, .4.4, .5.1, .5.3, .5.4, .5.8, .5.10
4. Sept 22-26
SQL
Ch 3: .6.1a-d, .6.2, .6.4, .7.1, .7.2, .7.3a-c, .7.8, Project 2
5. Sept 29-Oct 3
Ch. 5 Relational Algebra
Ch 6: .1.2, .1.6, .2.1, .3.1, .3.3, .3.5, .3.6, .3.11, .4.3
6. Oct 6-10
Relational Algebra; Ch. 7 Constraints and Triggers Ch6: .5.1adeg, .6.2acf, .6.4, .7.1ab, .7.3ab; Ch 5: .2.1acfhj, .2.9, Project 3
7. Oct 13-17
Monday: no class, Fall Holiday; Ch. 8 Embedded SQL no assignment (thanks in part to Kirsten)
8. Oct 20-24
Mon: Embedded SQL; Wednesday: Mid-term (through Ch 6, SQL); Fri: Lunch at Dr. Iba's
no assignment due.  Suggested: Ch7: 7.1.1, 7.1.6, 7.2.2
9. Oct 27-31
Embedded SQL Ch7: 7.2.5; Suggested: .4.2; Project 4
10. Nov 3-7
Embedded SQL; Ch. 4 Other Data Models Ch 8: 8.1.1d, 8.1.3, 8.2.1d, 8.2.4; Suggested: 8.4.1(d), 8.5.1(d)
11. Nov 10-14
Other Data Models;
no HW problems due.  Suggested: Ch 8: 8.6.1ab,  8.6.4, 8.7.2; Project 5
12. Nov 17-21
Ch. 9 Object-Orientation in Query Langs; Ch. 4 Semi-structured data, XML

13 Nov 24-28
Ethical issues for databases; Wednesday & Friday: no class, Thanksgiving break
Project 6 (due Monday)
14 Dec 1-5
Data warehousing and mining, guest speaker Dr. Robert Nisbet; data in the real world; research topics in databases

15 Dec 8-12
Ch. 10 Logical Query Languages; Project demonstrations/presentations
Self Evaluation (due Monday) ; Project 7
16 Dec 15-19
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.