Home
Syllabus
Policies & Grading
» Recording/Copyright
» Campuswire
Class Schedule
Office Hours
Notes & Readings
Recitations
Assignments
» Submit
FAQ
Links
General Information

Instructor: Prof. Panos K. Chrysanthis (contact)
Recitations Instructor/TA: Rakan Alseghayer (contact)
Lectures: Tuesday/Thursday, 11:00am-12:15 pm
at 5129 Sennott Square
Recitations: Friday   10:00-10:50am (CRN# 16575 & 16574) and
Friday   12:00-12:50pm (CRN# 16576 & 17153)
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

Announcements
Dec. 15: HW5 sample solutions are posted
Dec. 12: HW6 sample solutions are posted
Dec. 9: Notes (Set #1) on Big Data, NOSQL, NewSQL & Data Streams are posted
Dec. 9: Notes (Set #1) on Query Processing & Optimization are posted
Dec. 8: Notes (Set #1) on Index Sturctures are posted
Dec. 6: HW5 is now due on Dec. 7
Dec. 3: Recitation 12 material is posted
Dec. 3: Notes (Set #2) on Storage & Files are posted
Dec. 2: HW6 is released & is due on Dec. 11
Nov. 30: Notes (Set #1) on Storage & Files are posted
Nov. 30: Notes (Set #4) on SQL Injection are posted
Nov. 22: Recitation 11 material is posted
Nov. 18: HW5 is released & is due on Dec. 6
Nov. 18: Notes (Set #3) on PL/SQL are posted
Nov. 18: HW4 sample solutions are posted
Nov. 17: Notes (Set #2) on PL/SQL are posted
Nov. 12: Recitation 10 material is posted
Nov. 11: Notes (Set #1) on ESQL & PL/SQL are posted
Nov. 11: Notes (Set #2) on Recovery are posted
Nov. 10: Notes (Set #1) on Recovery are posted
Nov. 5: Recitation 9 material is posted
Nov. 4: Reading on Recovery are posted
Nov. 4: Notes on Concurrency Control are posted
Nov. 3: Reading on Concurrency Control are posted
Nov. 3: Notes (Set #1) on SQL Transactions are posted
Nov. 3: Notes (Set #2) on SQL Integrity Contraints are posted
Nov. 2: HW4 is released & is due on Nov. 15

[ News Archive ]


Copyright Panos K. Chrysanthis © 2021 Last updated on December 15, 2021 at 20:31:07 EST