CS 353: Database Systems

Fall 2026

Instructor: Hamdi Dibeklioglu

Office hours: by appointment

TAs: TBA
Class hours & room:

Section 1: Tuesday 09:30-10:20; Thursday 13:30-15:20 (EB-204)
Section 2: Monday 15:30-16:20; Thursday 10:30-12:20 (EB-104)

Announcements:

Regularly check here for the announcements

Objectives:

Understand the concepts underlying the design and implementation of database systems.
Establish a solid background in data management, with a focus on relational database management systems.
Practice actual database design, implementation, and query formulation through a term project.

Course Outline:

Relational Data Model
Relational Algebra
Entity/Relationship Model
Structured Query Language, SQL
Relational Database Design - Normalization
File Organization
Tree-Structured Indexing
Hash-Based Indexing
Query Processing
Query Optimization
Transactions & Concurrency Control

Typical Grading:

Midterm: 30%
Final: 40%
Project: 20%
Homeworks: 10%

All assignments must be uploaded to Moodle as a single PDF.

Minimum Requirements to Qualify for the Final Exam:
In order to qualify for the Final Exam, the Midterm Exam grade must be at least 30 out of 100.

Textbook and References:

Required	Textbook	Database System Concepts, 7th edition	A. Silberschatz; H. Korth; S. Sudarshan	McGraw- Hill	2019
Recommended	Textbook	Database Management Systems, 3rd Edition	R. Ramakrishnan, J. Gehrke	McGraw- Hill	2003
Recommended	Textbook	Database Systems, The Complete Book, 2nd edition	Hector Garcia-Molina,Jeffrey D. Ullman, Jennifer Widom	Prentice Hall	2009
Recommended	Textbook	An Introduction to Database Systems, 8th Edition	C.J. Date	Addison-Wesley	2004
Recommended	Textbook	Fundamentals of Database Systems, 6th Edition	Ramez Elmasri, Shamkant B. Navathe	Addison- Wesley	2011

Warning:
Cheating in exams, homeworks, and projects in this course will be seriously dealt with, leading to punishment through disciplinary procedures.