Information about CSE 444 will gradually appear on this site.

Course Syllabus

Day by day lecture schedule

- Slides of the introduction lecture
- Object Design Language (ODL) (Sec. 2.1)
- Entity/Relationship Diagrams (Sec. 2.2, 2.3)
- Modeling subclasses in ODL and E/R (Sec. 2.4)
- Modeling constraints (Sec. 2.5, 2.6)
- The relational model (Sec. 3.1, 3.2)
- From E/R Designs to relational schema (Sec.3.3, 3.4)
- Functional Dependencies (Sec. 3.5, 3.6)
- Relational Algebra (Sec. 4.1)
- Slides from Wednesday, Jan 28 (relational algebra exercises)
- Normal Forms (Sec. 3.7)
- SQL (Sec. 5.1, 5.2)
- More SQL (Sec. 5.3, 5.4)
- Even more SQL (Sec. 5.5-5.8)
- Datalog and storage management (Sec. 4.2,4.3)
- Storage management
- SQL Server Notes
- Implementing Relational Operators
- Query Optimization
- SQL Constraints
- Triggers and Embedded SQL (Sections 6.5-6.6, 7.1)
- Concurrency control and recovery (Section 7.2 and more)
- Slides from friday 3/6 will be here on monday. (Sections 8.1, 8.2)
- Objects in SQL3, Recursion (Sections 4.4, 5.10, 8.5, 8.6)

- Homework #1
- Homework #1 Solutions
- Homework #2
- Homework #2 Solutions
- Practice HW Solutions
- Homework #3
- Homework #3 Solutions
- Homework #4
- Homework #4(1-3) Solutions
- Homework #4(4) Solution