CSE-444: Introduction to Database Systems
Information about CSE 444 will gradually appear on this site.
Course Syllabus
Day by day lecture schedule
(Powerpoint) Lecture Slides
The parentheses indicate the corresponding sections in the book.
- 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)
Homeworks
The other book I've been using is: Database Management Systems by
Raghu Ramakrishnan, published by McGraw Hill. There is a
web page for this book.
Hypermail archive