TÜRKÇE
ENGLISH
Information
| Code | ENM352 |
| Name | Database Management and Data Mining |
| Term | 2024-2025 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 |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Arş.Gör.Dr. IRFAN MACIT |
| Course Instructor |
1 2 |
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 | Have sufficient knowledge of mathematics, science and related engineering disciplines; can use the theoretical and applied knowledge in these fields in complex engineering problems. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Acquire the ability to identify, define, formulate and solve complex Industrial Engineering problems; for this purpose, will have the ability to choose and apply appropriate analysis and modeling methods. | 1 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Design a complex system, process, device or product to meet specific requirements under realistic constraints and conditions; can apply modern design methods for this purpose. | 1 |
| PLO04 | Bilgi - Kuramsal, Olgusal | Develops modern techniques and tools necessary for the analysis and solution of complex problems encountered in engineering applications, and has the ability to use information technologies effectively. | 1 |
| PLO05 | Bilgi - Kuramsal, Olgusal | Have the ability to design experiments, collect data, analyze and interpret results for the investigation of complex engineering problems or discipline-specific research topics. | 1 |
| 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 orally and in writing; knowledge of at least one foreign language; have the ability to write effective reports and understand written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. | |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | Have the awareness of the necessity of lifelong learning; can follow the developments in science and technology and have the ability to constantly renew themselves. | 3 |
| PLO09 | Yetkinlikler - Öğrenme Yetkinliği | Acts in accordance with ethical principles, has knowledge about the standards used in engineering applications with the awareness of professional and ethical responsibility. | 4 |
| PLO10 | Yetkinlikler - Öğrenme Yetkinliği | Gain knowledge of business practices such as project management, risk management and change management; become aware of entrepreneurship and innovation. | 2 |
| PLO11 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Gains knowledge about the effects of engineering practices on health, environment and safety in universal and social dimensions and the problems of the age reflected in the field of engineering and has awareness of the legal consequences of engineering solutions. | |
| PLO12 | Yetkinlikler - Öğrenme Yetkinliği | They can benefit from the power of effective communication in their professional life and have the ability to interpret developments correctly. | 2 |
| PLO13 | Yetkinlikler - Öğrenme Yetkinliği | Have the ability to design, develop, implement and improve integrated systems involving machine, time, information and money. | 3 |
| PLO14 | Yetkinlikler - Öğrenme Yetkinliği | Have the ability to design, develop, implement and improve complex products, processes, businesses, systems by applying modern design methods, under realistic conditions and constraints such as cost, environment, sustainability, manufacturability, ethical, 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ş |
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 | ||