General Information

Instructors:   Dr. Panos K. Chrysanthis (contact)
Recitations Instructor/TA: Brian T. Nixon (contact)
TA/grader: Yoshita Reddy Buthalapalli (contact)
Lectures: Tuesday/Thursday, 11:00 am - 12:15 pm
at 5129 Sennott Square
Recitations: Friday     9:00-9:50am   (CRN# 15603 & 15602) and
Friday   11:00-11:50am (CRN# 15604 & 16129)
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 (46 currently registered) and 6 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: PostgreSQL: The World’s Most Advanced Open Source Relational Database

Announcements
Dec. 10: HW5 sample solution is posted
Dec. 9: Recitation 13 solution is posted
Dec. 8: Notes (Sets #1) on Recovery were posted
Dec. 8: Notes (Sets #2) on Indexing were posted
Dec. 8: Recitation 13 material is posted
Dec. 6: Notes (Sets #1) on Indexing were posted
Dec. 2: Recitation 12 solution is posted
Dec. 1: Recitation 12 material is posted
Dec. 1: Notes (Sets #2) on Data Storage were posted
Nov. 29: Notes (Sets #1) on Data Storage were posted
Nov. 29: Notes (Sets #1) on SQL Access Control were posted
Nov. 29: HW5 is released & is due on Dec. 10
Nov. 29: HW4 sample solution is posted
Nov. 24: Notes (Sets #1-2) on Data Warehousing are posted
Nov. 18: Recitation 11 solution is posted
Nov. 17: Recitation 11 material is posted
Nov. 15: Notes (Sets #2) on DB External Programming are posted
Nov. 11: Recitation 10 solution is posted
Nov. 10: Notes (Sets #1) on DB External Programming are posted
Nov. 10: Recitation 10 material is posted
Nov. 10: Project demo exam is on Dec. 16
Nov. 10: Project Phase 2 and 3 new dates are Dec. 5 and Dec. 15
Nov. 9: Notes (Sets #2) on DB Internal Programming are posted
Nov. 4: Recitation 9 solution is posted
Nov. 3: Notes (Sets #1) on DB Internal Programming are posted
Nov. 3: Recitation 9 material is posted
Nov. 1: Notes (Sets #3 & #4) on TP/Concurrency Control are posted

[ News Archive ]