General Information

When:   Section I: Tuesday/Thursday, 11:05am - 12:20 pm
  Section II: Monday/Wednesday, 5:00 - 6:15 pm
Where: Section I: 157 Benedum Hall (Zoom)
Section II: 404 Information Science Building (Zoom)
Instructors:   Prof. Panos K. Chrysanthis (contact)
  Prof. Constantinos Costa (contact)
Recitations Instructor: Rakan A. Alseghayer (contact)
TA & Grader: Brian T. Nixon (contact)
Recitations: Section I: Fri.   11:05-11:55am @ WWPH 5601 (Zoom)
Section I: Fri.   2:20-3:10pm @ WWPH 5601 (Zoom)
Section II: Fri.   8:55-9:45am @ WEB (Zoom)
Section II: Fri.   4:30-5:20pm @ WEB (Zoom)

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 28+37 students in 1555 (28+37 currently registered) and 1+1 in 2055 (1+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

Nov. 22: HW8 Practice and its Solution was posted (No due date)
Nov. 22: HW7 Solution was posted
Nov. 21: Notes on Indexing and Transaction Processing were posted
Nov. 16: HW6 Solution was posted
Nov. 16: Recitation 12 video and solutions are posted
Nov. 13: Notes on Data Storage were posted
Nov. 13: Notes on E-R/EER Diagrams/UMLs were posted
Nov. 12: HW7 was posted & is due on Nov. 20
Nov. 5: Notes on DB Design & E-R Model were posted
Nov. 5: Notes (Set #2) on DB Design & Normalization were posted
Nov. 2: HW6 was posted & is due on Nov. 12
Oct. 31: HW5 Solution was posted
Oct. 31: Project was released & is due on Nov 24
Oct. 29: Notes (Set #1) on DB Design & Normalization were posted
Oct. 28: Notes on JDBC were posted
Oct. 20: Notes on SQL Programming (PLSQL) & Embedded SQL were posted
Oct. 20: Recitation 8 video is posted
Oct. 17: The reading On SQL Programming (PLSQL & Embedded SQL) for next week is posted
Oct. 17: Notes & Videos on SQL Programming (PLSQL) were posted
Oct. 16: Recitation 8 solution is posted
Oct. 15: HW5 (Project Milestone 1) was released & is due on Oct 29
Oct. 10: Midterm Review video is posted
Oct. 9: Midterm Review slides are posted
Oct. 9: The reading On SQL programming is posted
Oct. 9: HW4 Solution was posted
Oct. 5: Recitation 7 video and solution are posted
Oct. 2: The reading On SQL Access, IC & Transactions for next week is posted
Oct. 2: Notes & Videos on SQL ML (#3) were posted

[ News Archive ]