| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| Database Management Systems | BM309 | Turkish | Compulsory | 5. Semester | 4 + 0 | 4.0 | 6.0 |
| Prerequisite Courses | |
| Course Level | Undergraduate |
| Mode of delivery | Face-to-Face |
| Course Coordinator | Doç. Dr. Fatih KAYAALP |
| Instructor(s) | Doç. Dr. Fatih KAYAALP (Güz) |
| Goals | Solving a problem and modeling the processes involved. (formal system analysis) To design a conceptual database using E-R (entity-relationship) diagrams. Identifying constraints, Implementing and executing database objects (table, constraint, index, etc.); Perform basic and advanced database operations using SQL and stored procedures/functions and triggers |
| Course Content | ER diagrams, Normalization, Relational Algebra, Database design and creation, Table, Procedure, Trigger etc. creation of database components, creation of basic and advanced reports with SQL |
| # | Öğrenme Kazanımı |
| 1 | Gain knowledge about the basic concepts of the database world |
| 2 | Have knowledge about database models and relational model |
| 3 | Gains knowledge of Relational Algebra infrastructure |
| 4 | Have knowledge about modeling the database with entity-relationship diagrams and creating the database schema from these models and can do it. |
| 5 | Gets knowledge about normalization and apply normalization operations on databases. |
| 6 | Can do CRUD operations on databases with SQL |
| 7 | Gets information about subqueries, grouping and join types in SQL; then can do advanced analysis on databases |
| 8 | Gets informaton about database components such as stored procedure, trigger, index, view etc. and can use them for advanced database operations |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | Data and Database Concepts | |
| 2. Week | Entity-relationship model | |
| 3. Week | Relational Data Model | |
| 4. Week | Relational Algebra, Normalization | |
| 5. Week | Database Design | |
| 6. Week | SQL-Record operations | |
| 7. Week | SQL-Subqueries | |
| 8. Week | SQL-Join Operations | |
| 9. Week | Views | |
| 10. Week | Triggers | |
| 11. Week | Stored Procedures | |
| 12. Week | Indexes | |
| 13. Week | User Permissions, Backup/Restore | |
| 14. Week | Student Project Presentations |
| No | Program Requirements | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Adequate knowledge of mathematics, science and related engineering disciplines; Ability to use theoretical and applied knowledge in these fields in complex engineering problems | ✔ | |||||
| 2 | Ability to identify, define, formulate and solve complex engineering problems; for this purpose, the ability to select and apply appropriate analysis and modeling methods | ✔ | |||||
| 4 | Ability to design a complex system, process, device or product to meet specific requirements under realistic constraints and conditions; for this purpose, the ability to apply modern design methods | ✔ | |||||
| 5 | Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself | ✔ | |||||
| 7 | Ability to work effectively in disciplinary and multi-disciplinary teams; individual study skills | ✔ | |||||
| 8 | Ability to develop, select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in engineering practice; Ability to use information technologies effectively | ✔ | |||||
| 10 | Ability to communicate effectively in Turkish orally 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 and receive clear and understandable instructions | ✔ | |||||
| Program Requirements | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | DK7 | DK8 |
|---|---|---|---|---|---|---|---|---|
| PY1 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 |
| PY2 | 0 | 3 | 4 | 3 | 3 | 3 | 2 | 2 |
| PY4 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 |
| PY5 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 |
| PY7 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 |
| PY8 | 0 | 0 | 0 | 5 | 5 | 3 | 3 | 3 |
| PY10 | 0 | 0 | 0 | 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 |
|---|---|---|---|
| Doç. Dr. Fatih KAYAALP | N.Ö | Vize | 40.00 |
| Doç. Dr. Fatih KAYAALP | N.Ö | Final | 60.00 |
| Toplam | 100.00 | ||
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Ders İçi |
Class Hours | 14 | 4 | 56 |
|
Ders Dışı |
Preparation, After Class Study | 14 | 1.5 | 21 |
| Research | 14 | 1 | 14 | |
| Practice | 14 | 1 | 14 | |
|
Sınavlar |
Midterm 1 | 1 | 1.5 | 1.5 |
| Homework 1 | 1 | 31 | 31 | |
| Final | 1 | 1.5 | 1.5 | |
| Classroom Activities | 14 | 1 | 14 | |
| Total Workload | 153 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 6.0 | ||
