General Information

Instructors:   Dr. Constantinos Costa (contact)
Recitations Instructor/TA: Rakan Alseghayer (contact)
TA & Grader: Nasrin Kalanat (contact)
Lectures: Tuesday/Thursday, 01:00-02:15 pm
at 5502 Sennott Square
Recitations: Friday   1:00-1:50pm (CRN# 27741 & 27740) and
Friday   2:00-2:50pm (CRN# 27743 & 27742)
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, 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 46 students in 1555 (45 currently registered) and 6 in 2055 (3 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: PostgreSQL: The World’s Most Advanced Open Source Relational Database

Apr. 22: Recitation 14 material is posted
Apr. 22: HW6 practice homework is posted
Apr. 22: HW5 sample solutions are posted
Apr. 19: Notes (Set #1)on Storage & indexing are posted
Apr. 16: Recitation 13 material is posted
Apr. 14: Notes (Set #1) on Recovery are posted
Apr. 13: Project Slide & Code are posted
Apr. 12: Notes (Set #1) on Concurrency Control are posted
Apr. 11: Project Phase 2 due date is extended to Apr. 13
Apr. 10: Recitation 12 material is posted
Apr. 8: HW5 is released & is due on Apr. 18
Apr. 7: Notes (Set #1) on DB External Programming are posted
Apr. 1: HW4 sample solutions are posted
Apr. 1: Recitation 11 material is posted
Mar. 29: Notes (Set #1) on Transaction Processing and DB Internal Programming are posted
Mar. 29: Notes (Set #1) on SQL Integrity Constraints are posted
Mar. 25: Recitation 10 material is posted
Mar. 25: Notes (Set #1) on SQL Views & SQL Access Control are posted
Mar. 21: Sample Data for the term project are posted
Mar. 20: Notes (Set #2) on DB Design - Normalization are posted
Mar. 20: HW4 is released & is due on Mar. 30
Mar. 20: Recitation 8 & 9 material is posted
Mar. 14: Midterm Review Slides are posted
Mar. 3: Notes (Set #1) on DB Design - Normalization are posted
Mar. 3: HW3 sample solutions are posted

[ News Archive ]