Study Material

Courses are not static.  Coverage varies a bit from term to term.   As a result, you may encounter in this material questions that are outside the scope of this term's course.  You may simply ignore them.

This page includes direct links to assignments and exams from terms in which K. Salem taught the course.  It also includes indirect links to material prepared by other instructors.

Old Assignments

• Spring 2001
• Assignment 1
• basic SQL questions
• model solution
• Assignment 2
•  ER model question
• model solution (Postscript)
•  Assignment 3
• SQL questions
•  model solution
• Fall 2000
• Assignment 1
• questions on basic SQL, relational algebra, relational calculus
• model solution (Postscript)
• Assignment 2
• questions on ER models
• model solution
• Assignment 3
• questions on SQL and normalization
• model solution (Postscript)
• Assignment 5
• questions on query evaluation and transactions
• model solution (Postscript)
• Winter 2000
• W00 Assignment 1
• questions on SQL
• model solution (plain text)
• W00 Assignment 3
• questions on ER models, normalization
• model solution
• W00 Assignment 4
• questions on query optimization and transactions
• model solution

Old Exams and Quizzes

• Spring 2000
•  Quiz 1 (Postscript)
• questions on SQL, relational algebra, relational calculus
•  model solution (Postscript)
•  Quiz 2 (Postscript)
• questions on ER models and FDs
•  model solution (Postscript)
•  Quiz 3 (Postscript)
• questions on normalization
•  model solution (Postscript)
•  Quiz 4 (Postscript)
• questions on transaction histories and concurrency control
•  model solution (Postscript)
•  Quiz 5 (Postscript)
• questions on transaction recovery and file structures
•  model solution (Postscript)
•  Midterm Exam (Postscript)
• questions on SQL, FDs, normalization, ER models, relational calculus and algebra
•  model solution (Postscript)
• F00 Midterm Exam (Postscript)
• questions on SQL, relational algebra and calculus, FDs and normalization, E-R models
• model solution (Postscript)
• W00 Midterm Exam (Postscript)
• questions on SQL, relational algebra, E-R models
• model solution

Other CS448/648 Material

 F01 CS448 main page   (Chan)

W01 Assignments and Model Solutions   (Özsu and Tompa)

S00 Assignments (Toman)