TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF ENGINEERING |
| INDUSTRIAL ENGINEERING PR. | |
| Code | ENM352 |
| Name | Database Management and Data Mining |
| Term | 2019-2020 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 | Öğr. Gör. Dr. İRFAN MACİT |
| Course Instructor |
Öğr. Gör. Dr. İRFAN MACİT
(Bahar)
(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
Resources
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 | - | Adequate knowledge in mathematics, science and related engineering discipline; ability to use theoretical and practical knowledge in these areas in complex engineering problems. | 4 |
| PLO02 | - | An ability to identify, formulate, and solve complex industrial engineering problems; the ability to select and apply appropriate analysis and modeling methods for this purpose. | 5 |
| PLO03 | - | An ability to design a complex system, process, device, or product to meet specific requirements under realistic constraints and conditions; the ability to apply modern design methods for this purpose. | 4 |
| PLO04 | - | Ability to develop, select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in engineering applications; ability to use information technologies effectively. | 4 |
| PLO05 | - | Ability to design, conduct experiments, collect data, analyze and interpret results for the study of complex engineering problems or discipline-specific research topics. | 5 |
| PLO06 | - | Ability to work effectively in disciplinary and multidisciplinary teams; self-study skills. | 4 |
| PLO07 | - | Ability to communicate effectively in Turkish presentation and in writing; knowledge of at least one foreign language; Ability to write effective reports and understand written reports, to prepare design and production reports, to make effective presentations, to give clear and understandable instruction and receiving skills. | 5 |
| PLO08 | - | Awareness of the necessity of lifelong learning; the ability to access information, follow developments in science and technology, and constantly renew oneself. | 5 |
| PLO09 | - | To act in accordance with ethical principles, professional and ethical responsibility awareness; information about standards used in engineering applications. | 5 |
| PLO10 | - | Information on business practices such as project management, risk management and change management; awareness about entrepreneurship and innovation; information on sustainable development. | 3 |
| PLO11 | - | Information about the effects of engineering applications on health, environment and safety in universal and social dimensions and the problems reflected in the engineering field of the age; awareness of the legal consequences of engineering solutions. | 3 |
| PLO12 | - | Ability to make use of the power of effective communication in professional life, to interpret the developments correctly and to make decisions. | 3 |
| PLO13 | - | Ability to design, develop, implement and improve integrated systems including machinery, time, information and money. | 2 |
| PLO14 | - | Ability to design, develop, implement and improve complex product, process, business, system design by applying modern design methods under realistic conditions and constraints such as cost, environment, sustainability, productivity, ethics, health, safety and political issues. | 4 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Database Management Introduction | Reading of related sources and lecture notes | |
| 2 | Database Design | Reading of related sources and lecture notes | |
| 3 | Data Normalization | Reading of related sources and lecture notes | |
| 4 | Data Queries | Reading of related sources and lecture notes | |
| 5 | Advanced Queries and Subqueries | Reading of related sources and lecture notes | |
| 6 | Forms | Reading of related sources and lecture notes | |
| 7 | Reports | Reading of related sources and lecture notes | |
| 8 | Mid-Term Exam | Study for Exam | |
| 9 | Calculations and Data Manupilation | Reading of related sources and lecture notes | |
| 10 | Application Development | Reading of related sources and lecture notes | |
| 11 | Access Software SQL Develepment | Reading of related sources and lecture notes | |
| 12 | Data mining Introduction | Reading of related sources and lecture notes | |
| 13 | Data mining Applications | Reading of related sources and lecture notes | |
| 14 | WEKA Data mining Software Introduction | Reading of related sources and lecture notes | |
| 15 | WEKA data mining applications | Reading of related sources and lecture notes | |
| 16 | Term Exams | Study for Exam | |
| 17 | Term Exams | Study for Exam |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 20 |
| General Assessment | ||
| Midterm / Year Total | 100 | 20 |
| 1. Final Exam | - | 80 |
| 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 | ||