Information Package / Course Catalogue
Database Management Systems
Course Code: KBU103
Course Type: Required
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 1
Credit: 4
Lab: 0
ECTS: 4
Objectives of the Course

To comprehend the basic terms and concepts of database. To provide a basis for relational data model, table data structure, relational algebra operations, basic SQL and advanced SQL queries, ODBC, programming of stored procedures and functions, development of triggers and database applications.

Course Content

To introduce database systems to students, to create database designs using E-R and relational data models for given database problems, to establish these designs as tables in the physical database, to be able to write and run the necessary queries on this physical database, to develop database applications using ODBC/JDBC, stored procedures and triggers.

Name of Lecturer(s)
Lec. Ahmet Cumhur ÖZTÜRK
Learning Outcomes
1.Recognize database management systems
2.Can create entity-relationship model
3.Understands the Relational Database Model
4.Can query with SQL
5.Can improve database
6.Able to design and manage databases
7.Recognize different database management systems
Recommended or Required Reading
1.arımağan, Ü. Database Systems. Academy & Turkish Informatics Foundation Joint Publication, 2000.
2.An Introduction to Database Systems, C.J. Date, Addison- Wesley, 2004, ISBN 0-321-19784-4.
Weekly Detailed Course Contents
Week 1 - Theoretical
Introduction to the basic concepts of database management systems
Week 2 - Theoretical
Logical database design with entity-relationship model
Week 3 - Theoretical
Relation model and relational algebra
Week 4 - Theoretical
Structured query language SQL: Basic queries
Week 5 - Theoretical
Structured query language SQL: Basic queries
Week 6 - Theoretical
Application development with advanced SQL and SQL programming
Week 7 - Theoretical
Indexing
Week 8 - Theoretical
Normalization
Week 9 - Theoretical
Appearances and movements
Week 10 - Intermediate Exam
Midterm Exam
Week 11 - Theoretical
Simultaneity
Week 12 - Theoretical
Recycling system
Week 13 - Theoretical
Object-oriented databases and XML
Week 14 - Theoretical
Open source and commercial database systems
Week 15 - Final Exam
Final Exam
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Rate1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory142256
Assignment25010
Midterm Examination117017
Final Examination117017
TOTAL WORKLOAD (hours)100
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
OÇ-1
4
4
OÇ-2
4
5
OÇ-3
5
4
OÇ-4
4
5
OÇ-5
5
4
OÇ-6
4
4
OÇ-7
4
Adnan Menderes University - Information Package / Course Catalogue
2026