601.315/415/615 - Databases

Instructor:

• David Yarowsky

Syllabus:

• PDF version

TAs, Office Hours and Review Sections:

• Current Office Hour Timetable available on Piazza.
• Additional Help Times for Final Project

Textbooks:

Assignments:

• Homework 1 - Due 10/5/2021
• Homework 2 - Due 10/21/2021
• 2020 Midterm TABLES for 601.315/415/615
• 2020 Midterm for 601.315
• 2020 Midterm for 601.415/615
• 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
• 2019 midterm for practice
• 2019 midterm for practice (tables)
• 2019 midterm sample solutions
• Homework 3 - Due 11/12/2021
• Project Phase I - Due 11/19/2021
• Homework 4 - Exam preparation and review
• Homework 4 - Problems 5 and 6
• Homework 4 - Exam preparation and review - Sample Solutions
• Project Phase II

Class Notes:

• Lecture 0 Notes (PDF)
• Topics on Final Exam (December 16, 2021, 6-9PM Baltimore time, Krieger 205)
• 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