TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| OFFICE TECHNOLOGIES AND DATA MANAGEMENT PR. | |
| Code | OVS205 |
| Name | Database Management II |
| Term | 2026-2027 Academic Year |
| Semester | 3. Semester |
| Duration (T+A) | 1-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 1.5 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Mahir ATMIŞ |
| Course Instructor |
The current term course schedule has not been prepared yet.
|
Course Goal / Objective
The aim of this course is to teach students the fundamental concepts of database systems and to provide skills in data modeling, storage, management, and querying. It also enables students to use SQL effectively and design database systems for real-world applications.
Course Content
This course covers the fundamental structure of database systems, data modeling techniques, and data management using SQL. Students develop skills in organizing, querying, and relating data, and gain the ability to design databases for real-world applications.
Course Precondition
none
Resources
For this course, commonly used reference books cover fundamental concepts of database systems, SQL queries, and design principles. Books such as “Database System Concepts” by Silberschatz, Korth, and Sudarshan and “Database Management Systems” by Ramakrishnan and Gehrke are widely recommended. These sources provide a strong foundation in data modeling, relational database design, and SQL applications.
Notes
In database and management courses, widely used reference books include Database System Concepts by Silberschatz, Korth, and Sudarshan and Fundamentals of Database Systems by Elmasri and Navathe. These books provide a strong theoretical and practical foundation, covering topics such as data modeling, relational database design, SQL queries, normalization, and database architecture.
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | 🇬🇧 Explains the fundamental concepts of database systems. |
| LO02 | Creates ER diagrams using data modeling techniques. |
| LO03 | Defines relational database structure and relationships between tables. |
| LO04 | Performs data querying using SQL. |
| LO05 | Executes insert, update, and delete operations using SQL. |
| LO06 | Applies data integrity and constraint rules. |
| LO07 | Improves database design using normalization techniques. |
| LO08 | Develops database solutions for real-world problems. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Have basic knowledge and concepts about Office Technologies and Data Management. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Knows problem solving methods and techniques related to Office Technologies and Data Management. | |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | Performs applications with basic knowledge and concepts in the field of Office Technologies and Data Management. | |
| PLO04 | Beceriler - Bilişsel, Uygulamalı | Has the ability to use the theoretical and practical knowledge acquired in the field of Office Technologies and Data Management. | 5 |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Explains and evaluates the basic knowledge and concepts on Office Technologies and Data Management. | |
| PLO06 | Yetkinlikler - Öğrenme Yetkinliği | Identifies problems by using basic knowledge and skills in their field. | |
| PLO07 | Yetkinlikler - Alana Özgü Yetkinlik | Analyze problems and develop solutions in the area. | |
| PLO08 | Bilgi - Kuramsal, Olgusal | Explains designs and applications related to Office Technologies and Data Management to subordinates and superiors as necessary. | |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | In the framework given at the basic level, you can function and take responsibility independently of the issues related to the field given to you. | 5 |
| PLO10 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Basic skills and knowledge of the area should be able to transfer effectively through written and oral communication. | 4 |
| PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Knowledge and skills to critically evaluate own learning and identify needs. | |
| PLO12 | Yetkinlikler - Alana Özgü Yetkinlik | By following the developments on the field of the profession,may point to a more advanced level. | 5 |
| PLO13 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | A1-A2-level Foreign Language(English) knows,can communicate in the foreign language relevant to the profession | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Basic computer operating systems,Office applications, and knows how to use the keyboard. | |
| PLO15 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | In accordance with the rules of Turkish language,written and oral communication effectively may establish. | |
| PLO16 | Bilgi - Kuramsal, Olgusal | Have sufficient awareness about Ataturk´s principles and revolutions. | 5 |
| PLO17 | Beceriler - Bilişsel, Uygulamalı | Professional, ethical, scientific and social values | |
| PLO18 | Yetkinlikler - Alana Özgü Yetkinlik | Global and social values within the framework of occupational health,safety and environmental is aware of the value. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Course introduction, introduction to databases, basic concepts | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 2 | Data, information and types of databases | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 3 | Data modeling (ER model) | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | Entity-Relationship diagrams | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 5 | Relational data model | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 6 | Key concepts (primary, foreign key) | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 7 | Introduction to SQL | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Repetition of topics from sources and lecture notes | Ölçme Yöntemleri: Yazılı Sınav, Proje / Tasarım |
| 9 | SQL queries (SELECT, WHERE) | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 10 | Insert, update, delete operations | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 11 | Table creation and data types | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | Relational queries (JOIN operations) | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | Functions and grouping | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap |
| 14 | Data integrity and constraints | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 15 | Review and practice / final exam preparation | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 16 | Term Exams | Repetition of topics from sources and lecture notes | Ölçme Yöntemleri: Yazılı Sınav, Proje / Tasarım |
| 17 | Term Exams | Repetition of topics from sources and lecture notes | Ölçme Yöntemleri: Yazılı Sınav, Proje / Tasarım |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 3 | 3 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 1 | 1 |
| Final Exam | 1 | 1 | 1 |
| Total Workload (Hour) | 75 | ||
| Total Workload / 25 (h) | 3,00 | ||
| ECTS | 3 ECTS | ||