601.315/415/615 - Databases

Instructor:

• David Yarowsky

Syllabus:

• PDF version

TAs, Office Hours and Review Sections:

• Current Office Hour Timetable available on Piazza.
• Office Hours and TA contacts (TBA)
• Piazza signup
• Gradescope access code: VW246K

Textbooks:

Assignments:

• Homework 1a - Due 9/22/25
• Homework 1b - Due 10/7/25
• Homework 2 - Due 10/29/25
• Homework 2 - Sample Solutions
• Homework 2 - JHU SQL Schema (updated)
• Homework 3 - Due 11/11/25
• Homework 3 - grades.sql
• Final Project Phase I - Due 11/21/25
• Final Project Phase II - Due end of semester
• Homework 4 - Due 12/12/25 as final exam practice problems

• 2020 Midterm TABLES for 601.315/415/615
• 2020 Midterm for 601.315 (PDF)
• 2020 Midterm for 601.415/615 (PDF)
• 2020 Midterm Sample Solutions for 601.315/415/615
• 2020 Midterm Question 5d corrected for 601.415/615
• 2020 Midterm Question 6b corrected for 601.415/615
• 2022 midterm for practice (please do under timed conditions)
• 2022 midterm for practice (tables)
• 2022 midterm for practice (sample solutions)
• notes regarding midterm

Class Notes:

• Lecture 0 Notes (PDF)
• Topics on Final Exam (December 15, 2025, 6-9PM Baltimore time, Hackerman B-17)
• All class slides to date
• MySql installation and use demo (PDF)
• Comparative analysis of SQL/RelAlgb/Domain+TupleRelCalc/English (PDF)
• Relational Algebra Examples (PDF)
• HW3 lecture slides (PDF)
• Notes on PL-SQL (PDF)
• Additional examples on MySQL stored procedures and PHP (html)
• Stored Procedure Examples
• Notes on MySQL/PHP/Web interaction (PDF)
• Notes on MySQL/PHP/Stored-Procedures interaction (PDF)
• MySQL-PHP-and-Perl.pdf [additional notes]
• Using mysql on Dbase [basic]
• mysql-storedprocedures.pdf [official MySQL documentation]
• mysql-views.pdf [official MySQL documentation]
• ADDITIONAL CLASS NOTES AND RESOURCES
• All remaining lecture notes are available in a class-only directory on the undergraduate network