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 (Fall 2026)
Piazza signup
Gradescope access code: EBJKKY
Textbooks:
Assignments:
Homework 1a - Due 9/24/2026
3c-completed-ER-with-keys-and-constraints
3d-Conversion-of-ER-to-Relational-Model.pdf
Homework 1b - Due 10/8/2026 at 11:59PM
Homework 2 - Due 10/28/2026 at 11:59PM
Homework 2 - jhusql2026b.txt database
Homework 2 - jhu.schema
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
additional functional-dependency examples covered in Midterm review sessions
additional programming examples covered in Midterm review sessions
HW1b sample solutions - part 2
HW1b sample solutions - part 3
HW1b sample solutions - full
HW2 sample solutions - part 1
HW2 sample solutions - part 2
2024 Midterm Sample Solution Set
Homework 3 - Due 11/12/26
Homework 3 (part g notes) - Due 11/12/26
Final Project Phase I - Due 11/20/26
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