Syllabus Application
CS 306
Database Systems
Faculty
Faculty of Engineering and Natural Sciences
Semester
Spring 2025-2026
Course
CS 306 -
Database Systems
Time/Place
Time
Week Day
Place
Date
10:40-11:30
Mon
SBS-G071
Feb 16-May 22, 2026
11:40-13:30
Wed
FENS-G077
Feb 16-May 22, 2026
Level of course
Undergraduate
Course Credits
SU Credit:3, 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
To supply the students with the theory and practice of database management systems, and database application development.
-
Course Materials
Resources:
All materials are on sucourse
Technology Requirements:
Laptops