| Course Name | Code | Semester | T+U Hours | Credit | ECTS |
|---|---|---|---|---|---|
| Database Management Systems | UYP 524 | 0 | 3 + 0 | 3 | 6 |
| Precondition Courses | |
| Recommended Optional Courses | |
| Course Language | Turkish |
| Course Level | yuksek_lisans |
| Course Type | Optional |
| Course Coordinator | Dr.Öğr.Üyesi ALPASLAN KİBAR |
| Course Lecturers | Dr.Öğr.Üyesi ALPASLAN KİBAR, |
| Course Assistants | Res.Ass.H.Serdar Geçer |
| Course Category | Field Proper Education |
| Course Objective | Introducing fundamentals and functions of database management, training students for the skills of implementing the necessary practices. |
| Course Content | Databases, E-R diagrams, systams analysis, modelling and implementation |
| # | Course Learning Outcomes | Teaching Methods | Assessment Methods |
|---|---|---|---|
| 1 | Modelling and Designing databases | Lecture, Question-Answer, | Testing, |
| 2 | Using a DBMS | Discussion, Question-Answer, Lecture, | Testing, |
| 3 | Critically analyzin an existing database | Discussion, Lecture, Question-Answer, | Testing, |
| 4 | Being able to design and implement a database project | Discussion, Lecture, Question-Answer, | Testing, |
| 5 | Solving database related problems | Discussion, Lecture, Question-Answer, | Testing, |
| 6 | Explaining the fundementals of databases and DBMS | Discussion, Lecture, Question-Answer, | Testing, |
| Week | Course Topics | Preliminary Preparation |
|---|---|---|
| 1 | Database: Definition and importance for the businesses and decision makers | |
| 2 | Database Project Management Phases | |
| 3 | Database Design: Entity-Relationship Diagrams | |
| 4 | E-R Modelling | |
| 5 | Advance İssues in E-R Modelling | |
| 6 | Logical Design and Relational Model | |
| 7 | Normalization and Exercises | |
| 8 | Midterm exam | |
| 9 | Physical Design and SQL | |
| 10 | Advance SQL Commands | |
| 11 | A Hospital Database Design with MS Access | |
| 12 | Managerial Issues with Databases | |
| 13 | Database Applications in different Departments | |
| 14 | Review |
| Resources | |
|---|---|
| Course Notes | |
| Course Resources | |
| Evaluation System | |
|---|---|
| Semester Studies | Contribution Rate |
| 1. Ara Sınav | 64 |
| 1. Ödev | 12 |
| 2. Ödev | 12 |
| 3. Ödev | 12 |
| Total | 100 |
| 1. Yıl İçinin Başarıya | 50 |
| 1. Final | 50 |
| Total | 100 |
| ECTS - Workload Activity | Quantity | Time (Hours) | Total Workload (Hours) |
|---|---|---|---|
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 2 | 32 |
| Mid-terms | 1 | 20 | 20 |
| Quiz | 2 | 6 | 12 |
| Performance Task (Laboratory) | 1 | 15 | 15 |
| Final examination | 1 | 15 | 15 |
| Total Workload | 142 | ||
| Total Workload / 25 (Hours) | 5.68 | ||
| dersAKTSKredisi | 6 | ||