ENM352 Database Management and Data Mining

4 ECTS - 3-0 Duration (T+A)- 6. Semester- 3 National Credit

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
Arş.Gör.Dr. IRFAN MACIT (A Group) (Ins. in Charge)


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

Update Time: 13.05.2024 02:16