| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| Database Management Systems | ENM205 | Turkish | Compulsory | 3. Semester | 3 + 0 | 3.0 | 4.0 |
| Prerequisite Courses | |
| Course Level | Undergraduate |
| Mode of delivery | |
| Course Coordinator | Dr. Öğr. Üyesi Ahmet ALBAYRAK |
| Instructor(s) | Dr. Öğr. Üyesi Ahmet ALBAYRAK (Güz) |
| Goals | To be able to define the concepts of database and database management systems, explain the functions of database management systems, to be able to realize the stages of database formation (requirement analysis, conceptual modeling, logical modeling and physical modeling) To be able to query, modify, add, delete data using SQL language Create and manage database in MySQL database management system |
| Course Content | Basic concepts, advantages and disadvantages of database, classical file system and database system, drawbacks of classical file systems, benefits of database system, basic features of database systems, data independence, data abstraction, data security, data integrity, data sharing, database system elements (database, database management system, hardware, software, users), database management system concept and architecture (external level, conceptual level, internal level and mappings), data models (hierarchical, network and relational), structural inquiry (SQL), commercial database systems, application development with MS access. |
| # | Öğrenme Kazanımı |
| 1 | 32/5000 To know the concepts of database, |
| 2 | To design a database |
| 3 | To be able to write queries using SQL query language |
| 4 | Ability to use functions, |
| 5 | Define rules |
| 6 | Ability to make authorizations |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | Introduction to Database Management Systems | Interview |
| 2. Week | Database Concepts | Interview |
| 3. Week | Relational Database Concepts | Interview |
| 4. Week | Database Users and Design | Interview |
| 5. Week | Relational Database and Normalization | Interview, Presentation (Preparation) |
| 6. Week | T-Sql Data Manipulation Language | Interview, Presentation (Preparation), Practice |
| 7. Week | T-Sql Data Query Language | Presentation (Preparation), Interview |
| 8. Week | T-Sql Data Definition Language | Presentation (Preparation), Interview |
| 9. Week | Database Operations with Sql Server Management Studio | Interview, Presentation (Preparation) |
| 10. Week | Views | Interview, Presentation (Preparation) |
| 11. Week | Stored Procedures | Interview, Presentation (Preparation) |
| 12. Week | Triggers | Presentation (Preparation), Interview |
| 13. Week | Sample Project 1 | Interview, Presentation (Preparation), Practice |
| 14. Week | Sample Project 2 | Interview, Presentation (Preparation), Practice |
| No | Program Requirements | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | To have theoretical and / or practical knowledge in the field of mathematics, science, social sciences, engineering and / or industrial engineering, and the ability to use this knowledge to model and solve engineering problems | ✔ | |||||
| 2 | Gaining the ability to work actively in projects and projects aimed at professional development in both individual and multidisciplinary groups and taking responsibility in situations that may arise in this process | ✔ | |||||
| 3 | Knowledge of at least one foreign language at a level that will enable communication with colleagues in the field and follow current developments; ability to write and understand written reports effectively, prepare design and production reports, make effective presentations, and give and receive clear and understandable instructions. | ✔ | |||||
| 4 | To be individuals who are sensitive to universal and social values, have knowledge of professional and ethical responsibilities and standards used in engineering practices. | ✔ | |||||
| 5 | The 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. | ✔ | |||||
| 6 | Ability to design and conduct experiments, collect data, analyze and interpret results to investigate complex engineering problems or discipline-specific research topics. | ✔ | |||||
| 7 | Ability to select and use modern techniques and tools necessary for the identification, formulation, analysis and solution of complex problems encountered in engineering applications; ability to use information technologies effectively. | ✔ | |||||
| 8 | Knowledge of business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; knowledge of sustainable development. | ✔ | |||||
| 9 | Knowledge of the universal and societal impacts of engineering practices on health, environment and safety, and contemporary issues reflected in the field of engineering; awareness of the legal consequences of engineering solutions, the necessity of lifelong learning and the ability to continuously renew oneself. | ✔ | |||||
| Program Requirements | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 |
|---|---|---|---|---|---|---|
| PY1 | 3 | 3 | 3 | 3 | 3 | 3 |
| PY2 | 3 | 3 | 3 | 3 | 3 | 3 |
| PY3 | 2 | 2 | 2 | 3 | 1 | 2 |
| PY4 | 4 | 4 | 4 | 4 | 4 | 4 |
| PY5 | 3 | 3 | 3 | 3 | 3 | 3 |
| PY6 | 4 | 4 | 4 | 4 | 4 | 4 |
| PY7 | 3 | 3 | 3 | 3 | 3 | 3 |
| PY8 | 4 | 4 | 4 | 4 | 4 | 4 |
| PY9 | 2 | 2 | 2 | 2 | 2 | 2 |
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| Güz Dönemi | |||
| Responsible Personnel | Grup | Evaluation Method | Percentage |
|---|---|---|---|
| Dr. Öğr. Üyesi Ahmet ALBAYRAK | Vize | 40.00 | |
| Dr. Öğr. Üyesi Ahmet ALBAYRAK | Final | 60.00 | |
| Toplam | 100.00 | ||
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Sınavlar |
Midterm 1 | 1 | 2.5 | 2.5 |
| Midterm 2 | 1 | 2.5 | 2.5 | |
| Homework 1 | 1 | 10 | 10 | |
| Homework 2 | 1 | 2.5 | 2.5 | |
| Final | 1 | 10 | 10 | |
| Practice | 2 | 10 | 20 | |
| Practice End-Of-Term | 2 | 10 | 20 | |
| Classroom Activities | 6 | 10 | 60 | |
| Total Workload | 127.5 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 4.0 | ||
