Information Systems Engineering
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

Ders Genel Tanıtım Bilgileri

Course Code:

EFC204

Ders İsmi:

Database Management Systems

Ders Yarıyılı:

Spring

Ders Kredileri:

Theoretical	Practical	Laboratory	ECTS
3	2	0	5

Language of instruction:

Turkish

Ders Koşulu:

Ders İş Deneyimini Gerektiriyor mu?:

Type of course:

Required

Course Level:

Bachelor

TR-NQF-HE:6. Master`s Degree

QF-EHEA:First Cycle

EQF-LLL:6. Master`s Degree

Mode of Delivery:

Face to face

Course Coordinator :

Asst. Prof. Dr. ZAFER GÜNEY

Course Lecturer(s):

Asst. Prof. Dr. ZAFER GÜNEY
Asst. Prof. Dr. MAHSA TORKAMANIAN AFSHAR

Course Assistants:

Dersin Amaç ve İçeriği

Course Objectives:

This course looks at the theoretical and technical issues involved in the implementation of generalized databases used to store and retrieve data. Course contents include introduction to databases, entity relationship model, physical database design and access strategies, relational data model, SQL data manipulation language, theoretical data manipulation language, normal forms and logical database design, query processing, concurrency control and recovery in databases, implementation of a simple storage manager and design of a relational database.

Course Content:

To introduce database systems to students, to create database designs using E-R and relational data models for given database problems, to set up these designs in the form of tables in the physical database, to write and run the necessary queries on this physical database, to develop database applications using ADO.NET, stored procedures and triggers.

Learning Outcomes

The students who have succeeded in this course;

Learning Outcomes

1 - Knowledge
Theoretical - Conceptual
2 - Skills
Cognitive - Practical
1) Gains sufficient knowledge about database systems, models and applies theoretical and applied knowledge in these fields to engineering problems.
2) Gains the ability to design and implement databases in accordance with rules and standards under realistic constraints and conditions.
3) Gains the ability to create and use database applications from SQL language in line with the needs of engineering problems.
4) Gains the ability to design, develop, report and present a database application project for a real-life need.
3 - Competences
Communication and Social Competence
Learning Competence
Field Specific Competence
Competence to Work Independently and Take Responsibility

Ders Akış Planı

Week	Subject	Related Preparation
1)	Introduction to databases	NA
2)	Relational Data Model-Relational Model	NA
3)	Relational Data Model-Relational algebra	NA
4)	Database design-ER Data Model	NA
5)	SQL-Constraints: Data-type, primary-key, second-key, not-null,column-constraints	NA
6)	SQL-Data definition language, Data manipulation language	NA
7)	SQL-Query language-Filtering and sorting operations	NA
8)	Midterm	Solving sample questions and homework, repeating the topic
9)	SQL-Subqueries- JOIN operations	NA
10)	SQL-Grouping	NA
11)	Database programming languages-T-SQL, PL/SQL	NA
12)	SQL-Stored procedures/functions	NA
13)	SQL-Triggers	NA
14)	ADO.NET Applications	NA
15)	Final Exam	Solving sample questions and homework, repeating the topic

Sources

Course Notes / Textbooks:	Veri Tabanı Sistemleri, Prof. Dr. Ünal Yarımağan, Papatya Yayınevi, 2021.
References:	Database Management Systems, 3rd Edition by Raghu Ramakrishnan (Author), Johannes Gehrke (Author), Mac Graw Hill.

Ders - Program Öğrenme Kazanım İlişkisi

Ders Öğrenme Kazanımları	1	2	3	4
Program Outcomes

Ders - Öğrenme Kazanımı İlişkisi

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

Program Outcomes

Level of Contribution

Assessment & Grading

Semester Requirements	Number of Activities	Level of Contribution
total		%
PERCENTAGE OF SEMESTER WORK		% 0
PERCENTAGE OF FINAL WORK		%
total		%