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