General Information

When:   Section I: Monday/Wednesday, 1:00 - 2:15 pm
  Section II: Tuesday/Thursday, 5:30 - 6:45 pm
Where: Section I: 5502 Sennott Square Building
Section II: 1501 W. W. Posvar Hall
Instructors:   Prof. Panos K. Chrysanthis (contact)
  Prof. Constantinos Costa (contact)
Recitations Instructor: Rakan A. Alseghayer (contact)
TA & Grader: Shubhrika Sehgal (contact)
Brian T. Nixon (contact)
Recitations: Fri.   1:00-1:50pm (CRN# 27599 & 27600) @ 5129 SENSQ
Fri.   5:00-5:50pm (CRN# 27653 & 27654 ) @ 6110 SENSQ
Wed.   9:00-9:50am (CRN# 29598 & 29597) @ 6110 SENSQ
Wed.   10:00-10:50am (CRN# 29599 & 29600) @ 6110 SENSQ

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, CS 0445 and CS1501 is required. Working knowledge of Java and familiarity with Unix are assumed.
Enrollment: Open to all students having the prerequisites;
max 44+44 students in 1555 (44+44 currently registered) and 6+6 in 2055 (2+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
Apr. 21: Notes & Videos on Concurrency Control and Recovery were posted
Apr. 21: Project Phase 3 new deadline is on Apr. 24
Apr. 18: HW7-HW9 sample solutions were posted
Apr. 17: Recitation 13, solutions, and videos are posted
Apr. 15: Notes & Videos on Index Structures were posted
Apr. 10: Recitation 12, solutions, and videos are posted
Apr. 9: Notes & Videos on data storage and files were posted
Apr. 9: Project Phase 2 new deadline is on Apr. 16
Apr. 5: HW9 was released & is due on Apr. 13
Apr. 3: Recitation 11, solutions, and videos are posted
Apr. 1: Notes & Videos on Conceptual DB Design (ER/EER/UML) were posted
Apr. 1: HW8 new deadline is on Apr. 3
Mar. 30: Project Phase 1 new deadline is on Apr. 3
Mar. 27: Recitation 10, solutions, and videos are posted
Mar. 26: HW8 was released & is due on Apr. 1
Mar. 25: Notes & Videos on RDB Design - Normalization were posted
Mar. 22: Project was released with multiple deadlines
Mar. 22: Notes & Videos on DB Programming-at-large were posted
Mar. 20: Notes (Set #4) on SQL Transactions were posted
Mar. 17: Recitation 9, solutions, and the video are posted
Mar. 17: Notes & Video on Onlline Course Logistics were posted
Mar. 16: HW7 was released & is due on Mar. 25

[ News Archive ]