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
Oct. 21: Special Office Hours of Instructor: 3:30-5:00pm
Oct. 21: Notes (Set #1) on Basic SQL DML were posted
Oct. 21: HW5 sample solution was released
Oct. 19: Recitation 8 handout was posted
Oct. 12: Recitation 7 Solution handout was posted
Oct. 12: Recitation 7 handout was posted
Oct. 11: Midterm new date is Oct. 23
Oct. 10: HW5 was released & is due on Oct. 19
Oct. 9: Notes (Set #2) on relational algebra were posted
Oct. 8: HW4 sample solution was released
Oct. 5: Recitation 6 Solution handout was posted
Oct. 5: Recitation 6 handout was posted
Oct. 3: Notes (Set #1) on relational algebra were posted
Oct. 3: Notes on EER Model & UML were posted
Sep. 28: Recitation 5 Solution handout was posted
Sep. 28: Recitation 5 handout was posted
Sep. 27: Notes on ER/EER to RDB Mapping were posted
Sep. 27: Notes on ER Model were posted

[ News Archive ]