Print Content

Course Information

Course Information

Course Title	Code	Semester	L+U Hour	Credits	ECTS
DATABASE MANAGEMENT SYSTEMS	YMH339	5. Semester	2 + 2	3.0	3.0

Prerequisites

None

Language of Instruction	Turkish
Course Level	Bachelor's Degree
Course Type	Compulsory
Mode of delivery
Course Coordinator
Instructors	Rukiye SAVRAN KIZILTEPE
Assistants
Goals	The aim of the Database Management Systems course is to provide students with in-depth knowledge and skills in database design, management, and optimization. This course aims to comprehensively teach students fundamental topics such as relational database models, data independence, SQL query language, normalization, database security, and performance management.
Course Content	Database Systems, Data Models, Entity-Relationship Model, Relational Database Model, Structured Query Language (SQL), SQL Operations, Database Security, Normal Forms (1NF, 2NF, 3NF, BCNF), Normalization of Database Schemas and Functional Dependencies, Data Integrity and Referential Integrity, User Management and Access Controls, Indexing and Query Optimization, Concurrency Control and Transaction Management, Database Security and Backup Strategies.
Learning Outcomes	1) Gains the ability to design a relational database. 2) Understand normal forms and perform normalization. 3) Design and develop a relational database system with appropriate functionality to process the data and with constraints to maintain data integrity and avoid data redundancy 4) Write SQL queries to retrieve and modify information from a database system. 5) Gains the competency to optimize the performance of relational databases.