TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF ENGINEERING |
| INDUSTRIAL ENGINEERING PR. | |
| Code | ENM352 |
| Name | Database Management and Data Mining |
| Term | 2025-2026 Academic Year |
| Semester | 6. Semester |
| Duration (T+A) | 3-0 (T-A) (17 Week) |
| ECTS | 4 ECTS |
| National Credit | 3 National Credit |
| Teaching Language | Türkçe |
| Level | Lisans Dersi |
| Type | Normal |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Arş.Gör.Dr. IRFAN MACIT |
| Course Instructor |
The current term course schedule has not been prepared yet. Previous term groups and teaching staff are shown.
|
Course Goal / Objective
The aim of the course is to design, develop and program a database system and to facilitate the basic concepts of
Course Content
Introduction to Database Management System, Database Design, Data Normalisation, Data Queries, Advanced Data Queries and Introduction to Data Mining and its Applications
Course Precondition
NONE
Resources
Lecture notes
Notes
Lecture notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Finding solutions to real life problems |
| LO02 | Being able to design a Database Management System |
| LO03 | Being able to use any of A Database Management System |
| LO04 | Implementing SQL Query Language |
| LO05 | Being able to use data mining techniques |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Acquires sufficient knowledge in mathematics, science and Industrial Engineering discipline-specific subjects; acquires the ability to use theoretical and applied knowledge in these fields in complex engineering problems. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Acquires the ability to identify, define, formulate and analytically solve complex Industrial Engineering problems; and has the ability to select and apply appropriate analysis and modelling methods for this purpose. | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Acquires the ability to design a complex system, process, device or product to meet specific requirements under realistic constraints and conditions; acquires the ability to apply modern design methods for this purpose. | 1 |
| PLO04 | Bilgi - Kuramsal, Olgusal | Acquires the ability to select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in Industrial Engineering applications and acquires the ability to use information technologies effectively. | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Acquire the skills to design and conduct experiments, collect data, analyze and interpret results to investigate complex Industrial Engineering problems or discipline-specific research topics. | |
| PLO06 | Bilgi - Kuramsal, Olgusal | Have the ability to work effectively in disciplinary and multi-disciplinary teams or individually. | 2 |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | Ability to communicate effectively in Turkish, both verbally and in writing; knowledge of at least one foreign language; ability to write and understand effective reports, prepare design and production reports, make effective presentations, and give and receive clear and understandable instructions. | |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | They have awareness of the necessity of lifelong learning; they have the ability to access information, follow developments in science and technology, and constantly renew themselves. | |
| PLO09 | Yetkinlikler - Öğrenme Yetkinliği | Acting in accordance with ethical principles, becoming knowledgeable about the standards used in engineering practices with awareness of professional and ethical responsibility. | 4 |
| PLO10 | Yetkinlikler - Öğrenme Yetkinliği | Learn about business practices such as project management, risk management and change management, and is aware of entrepreneurship and innovation. | |
| PLO11 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Informed about the universal and societal impacts of engineering practices on health, environment and safety, and the contemporary problems reflected in the field of engineering, and is aware of the legal consequences of engineering solutions. | |
| PLO12 | Yetkinlikler - Öğrenme Yetkinliği | Benefit from the power of effective communication in professional life and has the ability to interpret developments correctly. | |
| PLO13 | Yetkinlikler - Öğrenme Yetkinliği | Have the ability to design, develop, implement and improve integrated systems that include machines, people, time, information or money. | 3 |
| PLO14 | Yetkinlikler - Öğrenme Yetkinliği | By applying modern design methods, they have the ability to design, develop, implement and improve complex products, processes, businesses and systems under realistic conditions and constraints such as cost, environment, sustainable development, energy, manufacturability, ethics, health, safety and political issues. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Database Management Introduction | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım |
| 2 | Database Design | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 3 | Data Normalization | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | Data Queries | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 5 | Advanced Queries and Subqueries | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 6 | Forms | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 7 | Reports | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Study for Exam | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Calculations and Data Manupilation | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 10 | Application Development | Reading of related sources and lecture notes | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 11 | Access Software SQL Develepment | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | Data mining Introduction | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | Data mining Applications | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | WEKA Data mining Software Introduction | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 15 | WEKA data mining applications | Reading of related sources and lecture notes | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 16 | Term Exams | Study for Exam | Yöntem Seçilmemiş |
| 17 | Term Exams | Study for Exam | Yöntem Seçilmemiş |
Assessment (Exam) Methods and Criteria
Current term shares have not yet been determined. Shares of the previous term are shown.
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Project / Design | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
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 | 6 | 6 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 6 | 6 |
| Final Exam | 1 | 18 | 18 |
| Total Workload (Hour) | 100 | ||
| Total Workload / 25 (h) | 4,00 | ||
| ECTS | 4 ECTS | ||