Spring 2018 (18-2 or 2184) CS 1555/2055 : Database Management Systems Department of Computer Science      University of Pittsburgh
Home Syllabus Policies & Grading » Recording/Copyright » Piazza Class Schedule Notes & Readings Recitations Assignments » Submit » Project Info » System Docs FAQ Links		General Information When:   Section I: Tuesday/Thursday, 2:30 - 3:45 pm   Section II: Tuesday/Thursday, 4:00 - 5:15 pm Where: 5129 Sennott Square Building Instructors:   Prof. Panos K. Chrysanthis (contact)   Prof. Alexandros Labrinidis (contact) Recitations Instructor: Wei Guo (contact) TA & Grader: Xiaozhong Zhang (contact) Recitations: Friday   1:00-1:50pm (CRN# 31049 & 31050) at 5129 Sennott Square Building Friday   2:00-2:50pm (CRN# 29455 & 29458) Friday   4:00-4:50pm (CRN# 29456 & 29459) Friday   5:00-5:50pm (CRN# 31141 & 31142) 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 44+44 students in 1555 (44+44 currently registered) and 6+6 in 2055 (2+1 currently registered) Textbook: Fundamentals of Database Systems, 7th Edition Ramez Elmasri and Shamkant B. Navathe, Pearson (c) 2015 (ISBN-10: 0-13-397077-9; ISBN-13: 978-0-13-397077-7) 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. 22: HW #8 solutions were posted Apr. 22: Recitation 14 solution handout was posted Apr. 19: Recitation 14 handout was posted Apr. 18: Recitation 13 solution handout was posted Apr. 19: Final Class Notes were posted Apr. 12: Class Notes were posted Apr. 12: Solutions to assignments #6 aand #7 were posted Apr. 11: Recitation 12 solution handout was posted Apr. 6: Recitation 12 handout was posted Apr. 5: Class Notes were posted Apr. 4: Recitation 11 solution handout was posted Apr. 3: Assignment #8 was released Mar. 28: Recitation 11 handout was posted Mar. 28: Recitation 10 solution handout was posted Mar. 27: Assignment #7 handout and Class Notes were posted Mar. 22: Recitation 10 handout was posted Mar. 15: Recitation 9 solution handout was posted Mar. 15: Recitation 9 handout was posted Mar. 14: HW6 was posted Mar. 11: Recitation 8 solution handout was posted Mar. 1: Recitation 8 handout was posted Feb. 27: HW5 sample solution was posted Feb. 27: HW4 sample solution was posted Feb. 27: Notes (Set #2) on DML were posted Feb. 26: Recitation 7 solution handout was posted Feb. 22: Recitation 7 handout was posted Feb. 21: Notes (Set #2) on Concurrency Control were posted Feb. 19: HW5 was released & is due on Feb 26 Feb. 19: Recitation 6 solution handout was posted Feb. 19: Notes (Set #1) on Concurrency Control were posted Feb. 19: Notes (Set #1) on DML were posted Feb. 16: Notes (Set #3) on EER Model were posted Feb. 16: Recitation 6 handout was posted Feb. 14: Notes (Set #2) on Relational Algebra were posted Feb. 14: Recitation 5 solution handout was posted Feb. 10: HW4 was released & is due on Feb 17 Feb. 10: HW3 sample solution was posted Feb. 10: Notes (Set #1) on Relational Algebra were posted Feb. 8: Recitation 5 handout was posted Feb. 5: Recitation 4 solution handout was posted Feb. 3: HW2 sample solution was posted Feb. 2: Notes (Set #2) on E-R Model were posted Feb. 2: Recitation 4 handout was posted Feb. 1: HW3 was released & is due on Feb. 8 Jan. 31: Notes (Set #1) on E-R Model were posted Jan. 27: Recitation 3 solution handout was posted Jan. 26: Recitation 3 handout was posted Jan. 26: Notes (Set #3) on Normalization were posted Jan. 24: HW2 was released & is due on Jan. 31 Jan. 24: Notes (Set #2) on Normalization were posted Jan. 23: Recitation 2 solutions was posted Jan. 22: Notes (Set #1) on Database System Design were posted Jan. 22: Notes on SQL DDL were posted Jan. 19: HW1 was released & is due on Jan. 24 Jan 18: Recitation 2 handout was posted Dec. 15: Recitation 1 solutions was posted Jan. 15: Notes on Intro to relational Model were posted Dec. 12: Recitation 1 handout was posted Jan. 10: Notes on Intro to Databases were posted Dec. 30: First class: on Jan. 9 Dec. 30: First recitations on Jan. 12 [ News Archive ]
Copyright Panos K. Chrysanthis & Alexandros Labrinidis © 2018 Last updated on April 22, 2018 at 22:02:48 EST