600.315/415 - Databases

Instructor:

• David Yarowsky

Syllabus:

• PDF version

TAs, Office Hours and Review Sections:

• HW1 Review Session: Thursday 9/27, 4:15-5 PM (Yarowsky, Hackerman B-17)
• HW1 Review Session: Monday 10/1, 3-4 PM (Yarowsky, Hackerman 320)
• Standard TA Office hours: Times and Locations
• Final Exam Review Session: Tuesday 12/11, 12-1 PM (Yarowsky, Hackerman B-17)
• Topics on Final Exam

Textbooks:

Assignments:

• Homework 1 - PDF (due October 4, 2012)
• Homework 1 - Sample Solutions
• Homework 2 - PDF (due October 25, 2012)
• Homework 2 - PDF (copy 2) (due October 25, 2012)
• Homework 2 - QBE Schemas (cut and paste or print and use all) (due October 25, 2012)
• Homework 2 - Creating spool output file
• Homework 2 - Sample Solutions (SQL)
• Homework 2 - Output of Sample Solutions (SQL)
• Homework 2 - Sample Solutions (QBE)
• 2011 midterm
• 2011 midterm tables
• 2011 midterm (sample solution)
• Homework 3 - PDF (due November 20, 2012)
• Final Project Phase I - PDF (due November 27, 2012)
• 2012 midterm tables
• 2012 midterm (sample solution)
• Homework 4 - PDF (due December 11, 2012)
• Homework 4 - PDF (sample solution)
• Final Project Phase II - PDF (due December 17, 2012)

Class Notes:

• Lecture 0 Notes (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)
• Notes on MySQL/PHP/Web interaction (PDF)
• Notes on MySQL/PHP/Stored-Procedures interaction (PDF)
• Additional notes on stored procedures in MySQL and PHP/Perl embedding
• Information on MORI information visualization project
• ADDITIONAL CLASS NOTES AND RESOURCES
• All remaining lecture notes are available in a class-only directory on the undergraduate network