MIDTERM: The Databases midterm will be given in person in Hackerman B-17 from 3-4:15 EDT on Thursday 10/31. Students may stay until 4:30 PM to complete the exam without penalty if they are unable to finish in time. EXAM CONTENT: The midterm exam will cover all class content up to (and including) the functional dependencies classes. Topics include: * The substantial bulk of the exam will focus on the relational model and relational query languages: Relational Algebra, Tuple Relational Calculus, SQL and QBE: with multiple 5-minute queries to be written in these relational languages * Functional Dependencies, integrity constraints, Armstrong's axioms, FD closures and canonical cover, r satisfying F, F holding on r, formal candidate key determination using FDs Topics subsequent to these class will appear on the final exam. The content of the exams for 601.315 and 601.415/615 will differ substantially, with most 601.415/615 questions being more difficult than their 601.315 equivalent. All class slides are available at: http://www.cs.jhu.edu/~yarowsky/cs415.html The following comparative relational language slides are particularly helpful for exam preparation: http://www.cs.jhu.edu/~yarowsky/comparative.pdf MIDTERM EXAM RULES: The midterm will be closed-book and closed-note but you will be allowed to bring 1 double-sided sheets of notes (US 8.5x11 paper sized) - which has 2 written-on surfaces but should be on 1 physical page. You may include anything on these pages that you wish, including in handwriting, and/or cut and pasted notes in a printed document. As noted multiple times before, the only midterm and homeworks (and their solution sets) that may be viewed are those explicitly given on the 2024 class website. Access, use or review of any prior midterm or homework solution sets are expressly forbidden. While most questions on the 2024 exam will be entirely new for 2024, a subset may be adapted from other databases homeworks or exams given at some point in the past 20 years. As noted previously, two average question scores will be computed for each student, based on (1) the entirely new questions and (2) previously adapted questions. Student performance significantly higher on the previously adapted questions relative to the entirely new questions will be considered as evidence of violation of this rule.