Database Systems (CS 306)

2021 Fall
Faculty of Engineering and Natural Sciences
Computer Sci.& Eng.(CS)
3
6.00 / 6.00 ECTS (for students admitted in the 2013-14 Academic Year or following years)
Yücel Saygın -ysaygin@sabanciuniv.edu,
English
Undergraduate
CS204
Formal lecture,Recitation
Interactive,Communicative,Project based learning,Other
Click here to view.

CONTENT

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.

OBJECTIVE

To supply the students with the theory and practice of database management systems, and database application development.

LEARNING OUTCOME

After this course, the student will be able to develop a database application starting with the conceptual design leading to logical and physical designs.
After the course, the student will be competent on relational model and SQL.
After the course, the student will be able to implement a database application based on a given design.
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.
After the course, the student will be able to explain how a DBMS concurrently handles the transactions and what happens after a system crash.
After the course, the student will be able to explain how the data is physically stored, managed, and queried within the database.

ASSESSMENT METHODS and CRITERIA

  Percentage (%)
Final 35
Midterm 30
Participation 15
Individual Project 20

RECOMENDED or REQUIRED READINGS

Readings

Ramakrishnan and Gehrke, Database Management Systems, McGraw Hill