| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database Management Systems I | BLG1131 | 1. Semester | 2 + 2 | 3.0 | 4.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Associate |
| Course Type | |
| Mode of delivery | |
| Course Coordinator |
Lect. Tuba PALA |
| Instructor(s) |
Tuba PALA |
| Assistants | |
| Goals | |
| Course Content | |
| Learning Outcomes |
- Learn database management systems - Modeling the database with entity-relationship diagrams - Define the normalization steps - Querying databases with SQL |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Data and Database Concepts | |
| 2. Week | Entity-Relationship model | |
| 3. Week | Relational Data Model | |
| 4. Week | normalization | |
| 5. Week | Database Design | |
| 6. Week | SQL-Register operations | |
| 7. Week | SQL-Register operations | |
| 8. Week | SQL-Register operations | |
| 9. Week | SQL-Sub Queries | |
| 10. Week | SQL-Sub Queries | |
| 11. Week | SQL-Join Operations | |
| 12. Week | SQL-Join Operations | |
| 13. Week | Mini Project Examples | |
| 14. Week | Mini Project Examples |
| Veri Tabanı Yönetim Sistemleri 1 - Turgut Özseven Murathan Yayınevi |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | Measurement Method |
|---|---|---|---|---|---|---|
| PY1 | 5 | 0 | 0 | 0 | 0 | - |
| PY2 | 2 | 0 | 0 | 0 | 0 | - |
| PY5 | 1 | 0 | 0 | 0 | 0 | - |
| PY10 | 3 | 0 | 0 | 0 | 0 | - |
| PY11 | 5 | 0 | 0 | 0 | 0 | - |
| PY12 | 3 | 0 | 0 | 0 | 0 | - |
| PY15 | 5 | 0 | 0 | 0 | 0 | - |
| PY16 | 5 | 0 | 0 | 0 | 0 | - |
| PY17 | 3 | 0 | 0 | 0 | 0 | - |
| 0 | 1 | 2 | 3 | 4 | 5 | |
|---|---|---|---|---|---|---|
| Course's Level of contribution | None | Very Low | Low | Fair | High | Very High |
| Method of assessment/evaluation | Written exam | Oral Exams | Assignment/Project | Laboratory work | Presentation/Seminar |
| Event | Quantity | Duration (Hour) | Total Workload (Hour) |
|---|---|---|---|
| Midterm 1 | 1 | 10 | 10 |
| Homework 1 | 1 | 6 | 6 |
| Homework 2 | 1 | 6 | 6 |
| Final | 1 | 10 | 10 |
| Practice | 8 | 3 | 24 |
| Practice End-Of-Term | 6 | 3 | 18 |
| Classroom Activities | 14 | 2 | 28 |
| Total Workload | 102 | ||
| ECTS Credit of the Course | 4.0 | ||
