CSE-444: Introduction to Database Systems
Day by day lecture schedule
Details on class project
Project groups and e-mails
(Oct. 1st, Section 2.1)
E/R, subclasses, constraints
The relational model; converting conceptual models to database schemas.
Functional dependencies, normal forms.
End of normal forms. Relational algebra
How to use the tools for the project
(lecture by Zack Ives)
Updated sql slides
SQL Constraints and Triggers
Embedded SQL and Datalog
OQL and Object-relational Databases (Chapter 8)
DBMS architecture and storage management
Implementing relational operators
Homework #1 Solution
Homework #2 Solution
Homework #3 Solution
Homework #4 Solution
Last year midterm.
This year's midterm
This year's midterm solutions