The midterm exam was be held in class on Friday, April 28th. It covered the materials from lectures and sections through Wednesday of that week, along with HW1-3 and WQ1-4.
Here is our midterm and solution.
The final exam was be held on Thursday, June 8th from 2:30pm-4:20pm. While the exam was comprehensive, it focused mostly on materials covered after the midterm.
Here is one version of our final exam. The second version had very similar questions but very different answers.
Here are the "most correct" answers to that version of the final. However, note that, for several problems, alternate answers were also graded as correct — particularly, on problems where it looked like there was genuine room for confusion about the question or relevant assumptions.
SQL Practice: sql-practice-problems.txt and sql-practice-problems-answers.txt
Below are a few sample exams from previous offerings of 414 and 344 (version of the course for majors). Beware that the topics covered might be different, so some questions might not be applicable for this term. Please come to the lectures for instructions on what to study for the midterm and for the final.
Some solutions have mistakes. Be sure to check the list of errata here if you think you have encountered a mistake.