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

The aim of the Database Management Systems course is to equip students with the knowledge and skills to define the concepts of databases and database management systems, explain the functions of database management systems, perform the steps in creating a database, and create and manage databases using one of the current database management system software programs (Microsoft Access, MySQL, etc.).

Course Content

What is a database? What is a database management system? What does data modeling mean? What is a relational database? How are databases designed, created, and how is data entered and queried? What is a web-based database management system? How are web-based databases designed, created, how is data entered, queried, and made accessible?

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.Garcia-Molina, H., Ullman, J.D. ve Widom, J. (2013). Database Systems: The Complete Book. Pearson India Education.
2.Elmasri, R. ve Navathe, S.B. (2022). Fundamentals of Database Systems (7th Edition). Pearson.
3.Sumathi, S., Esakkirajan, S. (2007). Fundamentals of Relational Database Management Systems. Springer.
4.Petrov, A. (2019). Database Internals: A Deep Dive into How Distributed Data Systems Work. O'Reilly Media.
Weekly Detailed Course Contents
Week 1 - Theoretical
Database Concept, Database Examples, Basic Features of Databases
Week 1 - Preparation Work
Course Material
Week 2 - Theoretical
Database Management Systems, Advantages and Disadvantages of the Database Approach
Week 2 - Preparation Work
Course Material
Week 3 - Theoretical
Database User Types and Permissions, Data Models Used in Database Design, Database Types
Week 3 - Preparation Work
Course Material
Week 4 - Theoretical
Relational Databases, Database Objects and Key Definitions, Needs Analysis in Database Design
Week 4 - Preparation Work
Course Material
Week 5 - Theoretical
Conceptual Data Modeling, Preparation of Entity-Relationship Modeling
Week 5 - Preparation Work
Course Material
Week 6 - Theoretical
Limitations and Types of Relationships Related to Relationship Sets in the Entity-Relationship Model
Week 6 - Preparation Work
Course Material
Week 7 - Theoretical
Notations Used in the Entity-Relationship Model
Week 7 - Preparation Work
Course Material
Week 8 - Theoretical
Transformation of the Entity-Relationship Model into a Logical Model
Week 8 - Preparation Work
Course Material
Week 9 - Theoretical
Database Abnormalities and Database Normalization
Week 10 - Theoretical
Introduction to Database Management Systems (MySQL) (Knowing and defining data types, defining a database with the desired characteristics)
Week 11 - Theoretical
Performing operations in the MySQL database management system (Creating tables, defining constraints on tables, defining relationships between tables)
Week 11 - Preparation Work
Course Material
Week 12 - Theoretical
Performing operations in the MySQL database management system (Creating tables, defining constraints on tables, defining relationships between tables)
Week 12 - Preparation Work
Course Material
Week 13 - Theoretical
Performing operations in the MySQL database management system (Querying, modifying, deleting and adding data, creating indexes, creating triggers, backing up, loading)
Week 13 - Preparation Work
Course Material
Week 14 - Theoretical
Performing operations in the MySQL database management system (Querying, modifying, deleting and adding data, creating indexes, creating triggers, backing up, loading)
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
5
2
3
3
2
3
2
2
2
1
5
5
1
1
5
OÇ-2
4
3
3
3
2
3
2
3
2
1
5
5
1
1
5
OÇ-3
5
3
2
2
2
3
2
2
2
1
5
5
1
1
5
OÇ-4
4
2
2
2
2
3
2
2
2
1
5
5
1
1
5
OÇ-5
5
1
2
2
2
2
1
1
1
1
5
5
1
1
5
Adnan Menderes University - Information Package / Course Catalogue
2026