600.315/415 - Database Systems

Instructor:

• David Yarowsky

Syllabus:

• PDF version

TAs

 Urvashi Kathuria (head CA) - urvashi600.415 <at> gmail.com - Master's Lab (NEB-3floor, 6-5341)
 Poorva  Malviya - pmalviy1 <at> jhu.edu - Undergrad Lab NEB 225 (410-516-8412)

TAs, Office Hours and Review Sections:

• Tuesdays. - 12-2 PM NEB 332 (6-5341) - Urvashi Kathuria
• Wednesdays - 2-4 PM NEB 225/227 (6-8412) - Poorva Malviya
• Thursdays - 12-2 PM NEB 332 (6-5341) - Urvashi Kathuria
• HOMEWORK 1 Review Section - Wed 9/30 2-3 PM - CSEB 320 (Yarowsky)
• Midterm Review Section - Thursday 10/29 4:15 PM - CSEB B-17 (Yarowsky)

Textbooks:

Assignments:

• Homework 1 - PDF (due October 6, 2009)
• Homework 2 - PDF (due October 20, 2009)
• Homework 2 - schema for QBE (due October 20, 2009)
• Homework 1 - Sample Solution
• Homework 2a - Sample Solution
• Homework 2b - Sample Solution
• 2008 Midterm - Sample Solution
• 2008 Midterm - Supporting Tables
• Homework 3 - PDF (due November 17, 2009)
• Final Project Phase I - PDF (due November 19, 2009)

Class Notes:

• Lecture 0 Notes (PDF)
• Relational Algebra Examples (PDF)
• Notes on PL-SQL (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