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

Students of everyday life in many areas might encounter interrelated sets of data in computer storage and for effective management of data modeling, logical design concepts and data management allowing for the SQL query language to teach and widely used relational database management systems, Microsoft Access and Microsoft SQL Server database with enable them to develop applications.

Course Content

In this course, the database system data models and the importance of the Co-time control and operation (transaction) concepts, abstraction levels, data independence, log and database management system architecture, the active database design, relational algebra topics

Name of Lecturer(s)
Assoc. Prof. Halise ŞEREFOĞLU HENKOĞLU
Learning Outcomes
1.Data storage and management that have already learned about the use of conventional file filing system remembers and is aware of the inability of
2.May experience different areas of real-life data on the storage and management requirements analyzes.
3.Know how to make data modeling and logical design.
4.The widespread use relational database management system that knows the basic characteristics of
5.Organize the designed database with relational model
Recommended or Required Reading
1.1. Sumathi, S., Esakkirajan, S. (2010) Fundamentals of Relational Database Management Systems,
2.2. Springer-Verlag. -Elmasri, R., Navathe, S.B. (2004) Fundamentals of Datatabase Systems, Addison Wesley.
Weekly Detailed Course Contents
Week 1 - Theoretical
Data and Information Concepts
Week 1 - Preparation Work
Course Material
Week 2 - Theoretical
Historical Development of Database Management Systems
Week 2 - Preparation Work
Course Material
Week 3 - Theoretical
Data Modeling, Entity-Relationship Model
Week 3 - Preparation Work
Course Material
Week 4 - Theoretical
Relational Data Model and Relational Database Constraints
Week 4 - Preparation Work
Course Material
Week 5 - Theoretical
Relational Data Model and Relational Database Constraints
Week 5 - Preparation Work
Course Material
Week 6 - Theoretical
Logical Design
Week 6 - Preparation Work
Course Material
Week 7 - Theoretical
SQL (DDL) - Data Definition Language
Week 7 - Preparation Work
Course Material
Week 8 - Theoretical
SQL (DML) - Data Manipulation Language
Week 8 - Preparation Work
Course Material
Week 9 - Theoretical
Advanced SQL: Complex Queries
Week 10 - Theoretical
Database Normalization and Normal Forms
Week 11 - Theoretical
Object Oriented Databases
Week 11 - Preparation Work
Course Material
Week 12 - Theoretical
Implementation of Programs Database Connectivity
Week 12 - Preparation Work
Course Material
Week 13 - Theoretical
Implementation of Programs Database Connectivity
Week 13 - Preparation Work
Course Material
Week 14 - Theoretical
Course Evaluation
Week 14 - Preparation Work
Course Material
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory133265
Lecture - Practice131126
Assignment131013
Midterm Examination117118
Final Examination127128
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
OÇ-1
4
5
OÇ-2
4
5
4
3
OÇ-3
5
3
4
5
OÇ-4
4
3
4
OÇ-5
Adnan Menderes University - Information Package / Course Catalogue
2026