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).

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 ]