Study Group Weeks-3-4-DB-QUERY exercises KEY (using tables of Dept of Motor Vehicles DB)
Study Group Books.TablesStandard.WithConstraints (Combined Key for both Study Groups Jan 29/30 and Feb 5/6)
Study Group Books.UML.abbreviatedstandard.withConstraints (Key for Study Groups Feb 12/13 — UML of table and assertions in Books.TablesStandar.WithConstraints above)
Study Group StudyGroup Feb 19 and 20 KEY
Project Team keys for “Analysis of Doug’s Tables” and the UML for Doug’s Oberlin tables and assertions will be posted HERE as soon as server problems end, but they are also posted NOW on Oak, under “Project Auxiliary Material DormEnergy.UML.Standard ;
Midterm.1.Key with grading rubric in the case of most questions
Common Project 1 Design Errors
Exam2PracticeKey (plus ExamPracticeQ3 — two solutions to the Bank DB UML )
Exam2.Key — a student observed that 7(d) was taking an average BEFORE removing singleton groups, whereas the base query was taking the average after removing such groups — nice! I made adjustments to the grading criteria for that problem, but 7d remains a “fully correct” choice for purposes of score. Also see Exam2.3a.key.elaboration
Study Group on Transactions (April 9-10) Key: TransactionsExercises.Key