General Information

When:   Tuesday/Thursday, 11:00 am - 12:15 pm
Where: 5129 Sennott Square Building
Instructor: Prof. Panos K. Chrysanthis (contact)
Recitations Instructor & TA: Wei Guo (contact)
Recitations: Friday   11:00-11:50am (CRN# 17659 & 17657) and
Friday   2:00-2:50pm (CRN# 17660 & 18348)
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 42 students in 1555 (42 currently registered) and 6 in 2055 (0 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).

Sep. 18: Recitation 2 sample solution was posted
Sep. 14: Recitation 2 handout was posted
Sep. 14: Notes (Set #1) on SQL DDL were posted
Sep. 12: Notes (Set #3) on Relational Algebra were posted
Sep. 8: Recitation 1 and solution handouts were posted
Sep. 7: Notes (Set #2) on Relational Algebra were posted
Sep. 6: HW1 was released & is due on Sep. 12
Sep. 6: Notes (Set #1) on Relational Algebra were posted
Aug. 31: Notes on Relational Model were posted
Aug. 29: Notes on Intro to Databases were posted
Aug. 19: First class: on Aug. 28
Aug. 24: First recitations on Sep. 8

[ News Archive ]