University of Pittsburgh

School of Information Sciences

Graduate Information Science &Technology Program

INFSCI 2710: Database Management

Fall 2009

Class Announcements:
9/10/2009: Class notes for Thu 9/10/2009 are posted in the Class Materials section below.
9/17/2009: Complete Class notes are now posted in the Class Materials section below. Project description is also posted now.

9/18/2009: Because of traffic concerns related to the G20 event, all classes on the Oakland campus that begin on or after 4:00 p.m. on Thursday, September 24 will be cancelled. Hence, we will NOT have Database class on September 24th.
9/24/2009: Now, you have one more TA: Zheng Ma. His contact information is added below. Zheng has sent you your Knowledge Tree accounts.
10/1/2009: Knowledge Tree Slides are posted under the Class Material Section.
10/2/2009: Homework 1 is posted below in Homeworks Section! In Q2, you have to write SQL statements.
10/3/2009: In Q2, Follows(follower-id, following-id) implies e.g. Follows(Federer, Sampras) Federer follows Sampras tweets.
10/16/2009: Homework 2 is posted below. Check it out now!! (Due: Thursday, Oct 22).
10/19/2009: Q5. In the SQL statement: 'Twitter_person tp2' should be 'Twitter_profile tp2' and 'tr.usr_name1 = tp.usr_name' should be 'fr.usr_name1 = tp.usr_name'.
10/20/200910/22/2009: Next Today's class (on Thursday, 10/22/2009 will be held in Langley Hall (map) Room A 221 (floor plan). If you have a laptop, please try to bring it, and make sure Pitt Wireless (how to connect to PittNet) works on it.
10/22/2009: Project References and Code Sample for the Project are posted below in the Project Section. Please try to go through the code sample before you come to the class, so that it becomes easier for you to understand. It is ok, if you do not understand it as of now.
10/22/2009: Homework 1 will be returned today in the class.
10/27/2009: Homework solutions are posted below in the Homeworks section.

10/27/2009: Homework 3 is posted below in the Homeworks section (Due date: 12/3/2009).

Class Time and Place: Thu  6:00-8:50, IS403

Instructor:  Vladimir Zadorozhny
Office Hours:  TBA
Tel:    (412) 624 9411
e-mail: vladimir@sis.pitt.edu

GSAs:
Divyasheel Sharma
Office: DSL Lab, 2nd floor, SIS, Room B210
Office Hours: Thursday, 4-6 pm
Tel: (412) 624 7378
e-mail: dsharma@sis.pitt.edu

Zheng Ma
Office: Room 2B06, 2nd floor, SIS
Office Hours: Tuesday, 4-5 pm
e-mail: zhengma2001@gmail.com

 

This is  a basic graduate course on database systems. The major focus of this course is on centralized database systems. We will also cover  more advanced topics including data warehousing and OLAP as well as principles of distributed database systems. The coursework consists of homeworks, exams, and a team-oriented database design and implementation project.

Prerequisites

INFSCI 2500 or permission of instructor.

Topics Covered

Class Requirements and Grading

This course is being offered for three credits. The grading is as follows:

 

Homeworks

20%

Midterm Exam

20%

Final Exam

30%

Project

30% 

Late Policy: Homework and Project reports are due at the beginning of class on the due date. Homework and project reports can be turned in the following class for a 25% penalty. No assignments will be accepted after that time.

Project

Through the project, you will gain hands-on experience in designing and implementing a Data Warehouse System. The project is done in groups of 3 students and is documented by a written group report. A demo will be scheduled for each group.  The groups are ``self-policed''.

        Project description.

        Project References.

        Code Samples for the Project.

Textbook

 Raghu Ramakrishnan, Johannes Gehrke. Database Management Systems. 3d Edition. WCB/McGraw-Hill  2003

Homeworks

  • Homework 3:  pdf  due 12/3/2009

  • Homework 2:  pdf  due 10/22/2009 Q5. In the SQL statement: 'Twitter_person tp2' should be 'Twitter_profile tp2' and 'tr.usr_name1 = tp.usr_name' should be 'fr.usr_name1 = tp.usr_name'.
    HW2 Solutions: pdf

  • Homework 1:  pdf  due 10/8/2009, next Thursday at the beginning of the class hand it over to the Professor. In Q2. you have to write SQL statements.
    HW1 Solutions: ER Diagram Q1 Solution Q2 Solution

    • Class Materials