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
Feb. 28: Midterm Review Slides were posted
Feb. 28: HW6 sample solutions were posted
Feb. 24: Notes on Integrity Constraints in SQL were posted
Feb. 24: Notes on Access Control were posted
Feb. 21: HW6 was released & is due on Feb 27
Feb. 21: Recitation 7 solutions were posted
Feb. 21: HW5 sample solutions were posted
Feb. 20: Notes on SQL Views were posted
Feb. 20: Notes (set #2) on Basic SQL DDL were posted
Feb. 19: Recitation 7 was posted
Feb. 18: HW3 updated sample solutions were posted
Feb. 16: HW4 sample solutions were posted
Feb. 15: HW3 sample solutions were posted
Feb. 14: Recitation 6 solutions were posted
Feb. 13: HW5 was released & is due on Feb 19
Feb. 13: Notes (set #1) on Basic SQL DDL were posted
Feb. 12: Recitation 6 was posted
Feb. 8: Recitation 5 solutions were posted
Feb. 7: HW4 was released & is due on Feb 12
Feb. 5: Notes (set #2) on Relational Algebra were posted
Feb. 4: Recitation 5 was posted
Feb. 4: HW2 sample solutions were posted

[ News Archive ]