Database Systems (CS 306)

2025 Fall
Faculty of Engineering and Natural Sciences
Computer Sci.& Eng.(CS)
3
6
Yücel Saygın ysaygin@sabanciuniv.edu,
Click here to view.
English
Undergraduate
CS204 DSA201
Formal lecture,Recitation
Interactive,Communicative,Project based learning,Other
Click here to view.
Programs\Type Required Core Elective Area Elective
Computer Science and Engineering *
Computer Science and Engineering *
Data Science and Analytics *
Data Science and Analytics *
Electronics Engineering *
Electronics Engineering *
Industrial Engineering *
Industrial Engineering (Previous Name: Manufacturing Systems Engineering) *
Materials Science and Nano Engineering *
Materials Science and Nano Engineering (Previous Name: Materials Science and Engineering) *
Mechatronics Engineering *
Mechatronics Engineering *
Microelectronics *
Molecular Biology, Genetics and Bioengineering *
Molecular Biology, Genetics and Bioengineering (Pre. Name: Biological Sciences and Bioengineering) *
Telecommunications *

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 OUTCOMES

  • After the 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.

PROGRAMME OUTCOMES

1. Understand the world, their country, their society, as well as themselves and have awareness of ethical problems, social rights, values and responsibility to the self and to others. 1

2. Understand different disciplines from natural and social sciences to mathematics and art, and develop interdisciplinary approaches in thinking and practice. 1

3. Think critically, follow innovations and developments in science and technology, demonstrate personal and organizational entrepreneurship and engage in life-long learning in various subjects; have the ability to continue to educate him/herself. 1

4. Communicate effectively in Turkish and English by oral, written, graphical and technological means. 1

5. Take individual and team responsibility, function effectively and respectively as an individual and a member or a leader of a team; and have the skills to work effectively in multi-disciplinary teams. 1

1. Possess sufficient knowledge of mathematics, science, fundamental engineering, computational methods and program-specific engineering topics; use theoretical and applied knowledge of these areas in complex engineering problems. 1

2. Identify, define, formulate and solve complex engineering problems while considering the UN Sustainable Development Goals; choose and apply suitable analysis, design, estimation/prediction and modeling methods for this purpose. 4

3. Develop, choose and use modern techniques and tools that are needed for analysis and solution of complex problems faced in engineering applications; use information technologies effectively. 5

4. Have the ability to design a complex system, process, instrument or a product under realistic constraints and conditions, with the goal of fulfilling creative current and future requirements. 3

5. Use research methods, including conducting literature reviews, designing experiments, performing experiments, collecting data, analyzing results, and interpreting results, to investigate complex engineering problems or discipline-specific research topics. 1

6. Possess knowledge of business practices such as project management, risk management, change management, and economic feasibility analysis; awareness on entrepreneurship and innovation. 1

7. Possess knowledge of impact of engineering solutions on society, health and safety, the economy, sustainability, and the environment within the framework of the UN Sustainable Development Goals; awareness on legal outcomes of engineering solutions; awareness of acting impartially and inclusively without any form of discrimination; act in accordance with ethical principles, possessing knowledge of professional and ethical responsibilities. 1

8. Communicate effectively, both orally and in writing, on technical subjects, considering the diverse characteristics of the target audience (such as education, language, and profession). 3

ASSESSMENT METHODS and CRITERIA

  Percentage (%)
Final 50
Quiz 10
Group Project 40

RECOMENDED or REQUIRED READINGS

Textbook

Ramakrishnan and Gehrke, Database Management Systems, McGraw Hill