CS 1555/2055 : Database Management Systems (Fall 2009)

CS 1555/2055 : Database Management Systems

General Information

When:		Tue/Thu, 1:00 pm - 2:15 pm

Where:		5129 Sennott Square Building

Instructor:		Prof. Panos K. Chrysanthis (contact)



Recitations:		Fri 11:00-11:50pm (CRN# 36052, 36048 ) and Fri 2:00- 2:50pm (CRN# 36053, 36050)
		at 6110 Sennott Square Building

TAs:		Shenoda Guirguis (contact)) and Jesse Szwedko (contact)

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 (37 currently registered)

Textbook:		Fundamentals of Database Systems, 5th Edition. Ramez Elmasri and Shamkant B. Navathe, Addison-Wesley, 2006 (ISBN-10: 0-321-36957-2; ISBN-13: 978-032136957)

Announcements

Nov. 20:	Recitation 11 handout was posted.

Nov. 20:	HW5, the final assignment was released.

Nov. 20:	Notes on Physical Organization were released.

Nov. 18:	Notes on storage were released.

Nov. 14:	Recitation 10 handout was posted.

Nov. 14:	Notes on ER-2-Relational were released.

Nov. 9:	HW4 was released.

Nov. 9:	Project Sample data was released.

Nov. 7:	Recitation 9 handout was posted.

Nov. 6:	Recitation 8 handout was posted.

Nov. 4:	Notes on ER/EER Model were released.

Nov. 3:	Notes on Normalization were released.

Oct. 24:	HW3 Sample Solution was released.

Oct. 23:	Term Project was released.

Oct. 22:	Notes on Embedded SQL were released.

Oct. 19:	HW3 Sample data was released.

Oct. 16:	Recitation 7 handout was posted.

Oct. 16:	HW2 Sample Solution was released.

Oct. 15:	Notes on Advanced SQL DML were released.

Oct. 14:	HW3 was released.

Oct. 10:	Recitation 6 handout was posted.

Oct. 10:	Notes on SQL DML were released.

Oct. 5:	HW1 Sample Solution was released.

Oct. 3:	Recitation 5 handout was posted.

Oct. 1:	Notes on SQL DDL were released.

Sept. 29:	HW2 was released.

Sept. 23:	Notes on Relational Algebra were released.

Sept. 18:	Recitation 3 & 4 handout was posted.

Sept. 16:	HW1 was released.

Sept. 13:	Notes on Relational Model were released.

Sept. 11:	Recitation 1 and 2 handouts were posted.

Sept. 4:	Notes on DBMS introduction were released.

Sept 1:	First day of class:1:00pm - 2:15 pm (SENSQ 5129)

Sept 1:	First recitations on Sept 4


[ News Archive ]