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
• Current CA office hours spreadsheet
• Piazza signup (passcode emailed to all students)
• Gradescope access code: BK8EXK

Textbooks:

Assignments:

• Homework 1a - Due 10/1/24
• Homework 1b - Due 10/4/24
• Homework 1 help session
• Homework 2 - Due 10/23/24
• Homework 2 - jhu2024sql.txt
• 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
• Homework 3 - Due 11/07/24
• Homework 3 - Sample solution
• 2024 Midterm Sample Solution Set
• Project Phase I
• Project Phase 2
• Homework 4 - Exam preparation and review
• Homework 4 - Problems 5 and 6
• Homework 4 - Exam preparation and review (sample solution)
• Homework 4 - Additional notes from 12/15 review session

Class Notes:

• Lecture 0 Notes (PDF)
• Topics on Final Exam (December 16, 2024, 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