General Information

Instructors:   Dr. Constantinos Costa (contact)
  Prof. Panos Chrysanthis (contact)
When: Monday/Wednesday, 1:15pm – 2:30pm
316 Information Science Building (Zoom)
Recitations Instructor: Rakan A. Alseghayer (contact)
Fri.   1:15 – 2:05pm @ WEB (Zoom)
When: Fri.   3:25 – 4:15pm @ WEB (Zoom)
TA & Grader: Nasrin Kalanat (contact)
UTA: Gordon Lu (contact)

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 (2 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
Apr. 24: HW7 Solution was posted
Apr. 21: HW8 Practice and its Solution was posted (No due date)
Apr. 21: Notes & Videos on Indexing and Transaction Processing were posted
Apr. 17: Notes & Videos on Data Storage and Indexing were posted
Apr. 16: HW6 Solution was posted
Apr. 16: HW7 was posted & is due on Apr. 22
Apr. 8: Notes & Videos (Set #3) on DB Design & E-R Model were posted
Apr. 6: The Final Exam has been scheduled for April 28th
Apr. 6: Notes & Videos (Set #2) on DB Design & Normalization were posted
Apr. 5: HW6 was posted & is due on Apr. 15
Apr. 1: Project was released & is due on Apr 24
Apr. 1: HW5 Solution was posted
Apr. 1: Notes & Videos (Set #1) on DB Design & Normalization were posted
Apr. 1: Notes & Videos on JDBC were posted
Apr. 1: Notes & Videos on SQL Programming (PLSQL) & Embedded SQL were posted
Mar. 22: Notes & Videos on SQL Programming were posted
Mar. 19: HW5 (Project Milestone 1) was released & is due on Mar 26

[ News Archive ]