Spring 2012 (12-2 or 2124) CS 1555/2055 : Database Management Systems Department of Computer Science      University of Pittsburgh
Home Syllabus Policies & Grading Class Schedule Notes & Readings Recitations Assignments » Submit » Project Info System Docs FAQ Links		General Information When:   Mon/Wed, 4:30 - 5:45 pm Where: 5129 Sennott Square Building Instructor: Prof. Panos K. Chrysanthis (contact) TA: Lory Al Moakar (contact) Recitations: Friday   2:00-2:50pm (CRN# 23228 & 23229) and Friday   3:00-3:50pm (CRN# 23230 & 23231) at 6110 Sennott Square Building Purpose: There are two principle objectives for this course. First, to introduce the fundamental concepts necessary for the design and use of a database. Second, to provide practical experience in applying these concepts using commercial database management systems. Prereq: A grade of C or better in CS 0441 and CS 0445 is required. Working knowledge of Java and familiarity with Unix are assumed. Enrollment: Open to all students having the prerequisites; max 40 students in 1555 (32 currently registered) and 6 in 2055 (3 currently registered) Textbook: Fundamentals of Database Systems, 6th Edition Ramez Elmasri and Shamkant B. Navathe, Addison-Wesley (c) 2011 (ISBN-10: 0-13-608620-9; ISBN-13: 978-0-13-608620-8) Reference: Oracle10g Programming: A Primer, R. Sunderraman, Addison-Wesley, 2007 Learning SQL, 2nd Edition, Alan Beaulieu, O'Reilly 2009 (Available online from campus computers through Safari Bookshelf). Announcements Apr. 19: HW9 was released Apr. 19: HW8 sample solutions was posted Apr. 19: HW7 sample solutions was posted Apr. 19: Notes on transaction processing were posted Apr. 16: Recitation 11 notes and solutions were posted Apr. 11: Notes on query processing & optimization were posted Apr. 9: Notes on Indexing were posted Apr. 4: HW8 was released Mar. 28: Notes on Records & Files were posted Mar. 23: Recitation 10 notes and solutions were posted Mar. 21: HW7 was released Mar. 21: HW6 sample solutions was posted Mar. 21: Notes on Data Storage were posted Mar. 21: Notes (#2 & 3) on DB Design - ER/EER Modeling were posted Mar. 20: Term Project's new intermediate deadline (Phase 1) Mar. 18: Notes (#1) on DB Design - ER Modeling were posted Mar. 18: Recitation 9 notes and solutions were posted Mar. 13: HW6 was released Mar. 12: Notes (#2) on DB Design - Normalization were posted Mar. 12: Recitations 7-8 notes and solutions were posted Mar. 3: Notes on DB programming at large were posted Mar. 2: Term Project sample data was released Mar. 1: Term Project was released Mar. 1: Notes (#1) on DB Design - Normalization were posted Feb. 27: HW5 sample solutions was posted Feb. 27: HW4 sample solutions was posted Feb. 18: Recitation 6 notes and solutions were posted Feb. 15: HW5 on SQL Triggers was released Feb. 14: Notes (#2) on SQL Reliability were posted Feb. 11: Recitation 5 notes and solutions were posted Feb. 8: Notes (#1) on Advanced SQL Views were posted Feb. 8: HW4 on SQL Views was released Feb. 8: Notes (#2) on SQL DML were posted Feb. 8: HW3 sample solutions was posted Feb. 8: Notes (#1) on SQL DML were posted Feb. 8: HW2 sample solutions was posted Feb. 8: Recitation 4 notes and solutions were posted Jan. 31: HW3 on Basic SQL was released Jan. 30: Recitation 3 notes and solutions were posted Jan. 30: Notes on SQL DDL were posted Jan. 25: TA's new office hours Jan. 25: Notes (#2) on Relational Algebra were posted Jan. 25: HW1 sample solutions was posted Jan. 17: HW2 on Relational Algebra was released Jan. 21: Notes (#1) on Relational Algebra were posted Jan. 20: Recitation 2 notes and solutions were posted Jan. 17: HW1 on Relational Model was released Jan. 17: Recitation 1 notes and solutions were posted Jan. 12: HW0 on Sample eSubmission was released Jan. 11: Notes on Relational Model were posted Jan. 10: Notes of 1st class were posted Jan. 5: First recitations on Jan. 13 [ News Archive ]
Panos K. Chrysanthis Last updated on April 20, 2012 at 15:56:49 EST