Information Package / Course Catalogue
Database Management Systems
Course Code: MAT406
Course Type: Area Elective
Couse Group: First Cycle (Bachelor's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 2
Prt.: 2
Credit: 3
Lab: 0
ECTS: 6
Objectives of the Course

The purpose of this course is to help students understand the C programming logic and construct an implementation of C program

Course Content

The general structure and characteristics of database systems, the basic concepts in database management systems, the fundamental features and architectures of database technology, the history of database management systems, database models, the basic features, advantages, and disadvantages of the classical file system, data independence, data model stages, fundamental database concepts (table, field, record, attribute, etc.), database schema, data requirements, determining requirements, Entity-Relationship model (ER), database management system installation and basic concepts, creating queries with SQL, creating forms, queries, and reports with database management systems, Mathematical infrastructure of relational database, Cartesian product, correlation, relational algebra, Functional dependence, normalization, ensuring database security, maintenance, and backup.

Name of Lecturer(s)
Res. Assist. İclal GÖR
Learning Outcomes
1.Ability to understand fundamental concepts of database
2.Ability to understand disadvantages of classical file systems
3.Ability to understand database infrastructure and data modeling
4.Ability to understand fundamentals of database, types of relations and keys
5.Ability to design a database for a given problem
6.Ability to understand the duties of the database administrator, the application programmer and the database user
7.Ability to perform basic queries (add, delete, update and select) using SQL commands
8.Ability to perform basic queries (add, delete, update and select) using SQL commands
9.Ability to create a database user and share roles
10.Ability to provide database security
Recommended or Required Reading
1.Yrd. Doç. Dr. Nergiz Ercil Çağıltay, Dr. Gül Tokdemir, Veritabanı Sistemleri Dersi (Teoriden Pratiğe), (Database Systems from Theory to Practice), 2010
2.Elmasri, R. & Navathe, S. B. Fundamentals of Database Systems., Addison-Wesley, 2000
3.Kaya, Y. & Tekin, R. Veritabanı ve uygulamaları, Papatya yayıncılık, ( Database and applications), 2007.
Weekly Detailed Course Contents
Week 1 - Theoretical & Practice
General structure and characteristics of database systems, fundamental concepts in database management system
Week 2 - Theoretical & Practice
Key features and architectures of database technology, history of database management system, database models.
Week 3 - Theoretical & Practice
The basic features, advantages and disadvantages of classical file system, General structure and features of database systems, data independence, data model stages, Basic database concepts (table, field, record attributes, etc.)
Week 4 - Theoretical & Practice
Database schema, data requirement, the determination of requirements
Week 5 - Theoretical & Practice
Entity Relationship Model (ER)
Week 6 - Theoretical & Practice
The installation of Database Management System and basic concepts
Week 7 - Theoretical & Practice
The general features, standardization, of SQL (Structured Query Language), data types used in SQL, creating a new data type, creating a database, creating a table, updating a table, deleting an existing database, deleting an existing table.
Week 8 - Theoretical & Practice
The general features, standardization, of SQL (Structured Query Language), data types used in SQL, creating a new data type, creating a database, creating a table, updating a table, deleting an existing database, deleting an existing table (Midterm)
Week 9 - Theoretical & Practice
Inserting records into a table, updating existing records, deleting records, and performing basic querying operations using SQL commands, creating queries using constraints and auxiliary commands.
Week 10 - Theoretical & Practice
Inserting records into a table, updating existing records, deleting records, and performing basic querying operations using SQL commands, creating queries using constraints and auxiliary commands.
Week 11 - Theoretical & Practice
Creating forms, queries, and reports with Database Management Systems.
Week 12 - Theoretical & Practice
Mathematical infrastructure of relational database, Cartesian product, correlation, relational algebra
Week 13 - Theoretical & Practice
Functional dependence, normalization
Week 14 - Theoretical & Practice
Ensuring the security, maintenance, and backup of the database.
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140228
Lecture - Practice140228
Individual Work140342
Midterm Examination122224
Final Examination126228
TOTAL WORKLOAD (hours)150
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
PÇ-11
PÇ-12
PÇ-13
PÇ-14
PÇ-15
PÇ-16
PÇ-17
PÇ-18
OÇ-1
4
4
4
4
4
OÇ-2
4
4
4
4
4
OÇ-3
4
4
5
4
4
4
4
OÇ-4
4
4
4
4
4
OÇ-5
4
4
4
4
4
OÇ-6
4
4
5
4
4
4
4
OÇ-7
4
4
4
4
4
OÇ-8
4
4
4
4
4
OÇ-9
4
4
4
4
4
OÇ-10
4
4
4
4
4
Adnan Menderes University - Information Package / Course Catalogue
2026