Syllabus Application
Database Systems
CS 306
Faculty:
Faculty of Engineering and Natural Sciences
Semester:
Fall 2025-2026
Course:
Database Systems - CS 306
Classroom:
FENS-G077,FMAN-G071
Level of course:
Undergraduate
Course Credits:
SU Credit:3.000, ECTS:6, Engineering:6
Prerequisites:
CS 204 or DSA 201
Corequisites:
CS 306R
Course Type:
Lecture
Instructor(s) Information
Yücel Saygın
- Email: ysaygin@sabanciuniv.edu
Course Information
Catalog Course Description
This course covers the fundamental topics in database management systems including ANSI/SPARC architecture, data abstraction, data independence; data definition and manipulation languages; entity-relationship and relational data models, integrity constraints, query languages like SQL, relational algebra and calculus, functional dependencies, normal forms, transaction processing recovery and concurrency control, data structure for database management systems such as indices, B-trees, hashing.
Course Learning Outcomes:
| 1. | After the course, the student will be able to develop a database application starting with the conceptual design leading to logical and physical designs. |
|---|---|
| 2. | After the course, the student will be competent on relational model and SQL. |
| 3. | After the course, the student will be able to implement a database application based on a given design. |
| 4. | After the course, the student will be able explain the concept of functional dependency and will be able to avoid redundancies and other problems causing by bad designs. |
| 5. | After the course, the student will be able to explain how a DBMS concurrently handles the transactions and what happens after a system crash. |
| 6. | After the course, the student will be able to explain how the data is physically stored, managed, and queried within the database. |
Course Objective
-
Course Materials
Resources:
-
Technology Requirements:
-