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
• Gradescope access code: KKKV4V

Textbooks:

Assignments:

• Homework 1a - Due 9/21/23
• Homework 1b - Due 10/3/23
• Homework 2 - Due 10/18/23
• Homework 2 - SQL tables
• Homework 2 - Schema
• Homework 3 - Due 11/7/23
• 2020 Midterm TABLES for 601.315/415/615
• 2020 Midterm for 601.415/615 (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)
• Project Phase I - Due 11/16/23
• Project Phase 2
• Homework 4 - Exam preparation and review
• Homework 4 - Problems 5 and 6
• Homework 4 - Exam preparation and review - sample solutions

Class Notes:

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