CSE-444: Introduction to Database Systems

Details on class project

Lecture slides

• Introduction lecture (Sept. 28th)
• ODL (Oct. 1st, Section 2.1)
• E/R, subclasses, constraints (Sections 2.3-2.6)
• The relational model; converting conceptual models to database schemas. (Sections 3.1-3.4)
• Functional dependencies, normal forms. (Sections 3.5-3.8)
• End of normal forms. Relational algebra (Section 3.7.7,3.8,4.1)
• SQL. (Chapter 5)
• How to use the tools for the project (lecture by Zack Ives)
• Updated sql slides (Chapter 5)
• SQL Constraints and Triggers (Chapter 6)
• Embedded SQL and Datalog
• OQL and Object-relational Databases (Chapter 8)
• DBMS architecture and storage management
• Index structures
• Implementing relational operators
• Query optimization
• Transaction Processing
• Recovery

Homeworks

• Homework #1
• Homework #1 Solution
• Homework #2
• Homework #2 Solution
• Homework #3
• Homework #3 Solution
• Homework #4
• Homework #4 Solution

Last year midterm.

This year's midterm

This year's midterm solutions