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

CS 1555/2055 : Database Management Systems

General Information

When:		Tuesday/Thursday, 11:00 am - 12:15 pm

Where:		G28 Benedum Hall

Instructor:		Prof. Panos K. Chrysanthis (contact)


Recitations Instructor & TA:		Xiaozhong Zhang (contact)


Recitations:		Friday 11:00-11:50am (CRN# 17327 & 17997) and Friday 2:00-2:50pm (CRN# 17328 & 17325)
		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 45 students in 1555 (45 currently registered) and 3 in 2055 (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

Dec. 9:	HW7 sample solution was released

Dec. 7:	Recitation 14 Solution handout was posted

Dec. 7:	Recitation 14 handout was posted

Dec. 6:	Project(Phase 3) is now due on Dec. 9 (new deadline)

Dec. 6:	Notes on Indexing were posted

Dec. 4:	Notes on storage were posted

Nov. 30:	Recitation 13 Solution handout was posted

Nov. 30:	Recitation 13 handout was posted

Nov. 29:	HW7(last homework) was released & is due on Dec. 8

Nov. 29:	Notes on Recovery were posted

Nov. 16:	Notes on Concurrency Control were posted

Nov. 16:	Recitation 12 Solution handout was posted

Nov. 16:	Recitation 12 handout was posted

Nov. 15:	Notes on JDBC were posted

Nov. 14:	Notes on ESQL were posted

Nov. 10:	HW6 sample solution was released

Nov. 8:	Notes on SQL/PL were posted

Nov. 9:	Recitation 11 Solution handout was posted

Nov. 9:	Recitation 11 handout was posted

Nov. 5:	Notes on SQL Views and Access Control were posted

Nov. 2:	Recitation 10 Solution handout was posted

Nov. 2:	Recitation 10 handout was posted

Nov. 1:	Notes on SQL Transactions and Intergrity Constraints

[ News Archive ]