File organization and indexing. Sequential and direct file processing techniques. Indexed and hash files. Database management systems. Relational data model. Relational algebra and calculus. SQL query language. Database design. Database application development. Recovery and concurrency.
İlk dosyayı sen ekleyebilirsin — notlar, geçmiş finaller, çözümler, cheat-sheet, ne varsa. Drive linki / PDF / ZIP / fotoğraf, hepsi olur.
Şu an: mail at, ben düzenleyip yayına alayım. Form/upload UX yakında geliyor (Kimya tasarlıyor).
| Dönem | Course CPA | |
|---|---|---|
| 2025-2026 Fall | 2.96 | 2 sec · 135 öğr |
| 2024-2025 Fall | 2.53 | 2 sec · 130 öğr |
| 2024-2025 Spring | 2.60 | 2 sec · 102 öğr |
| 2023-2024 Fall | 2.60 | 2 sec · 148 öğr |
| 2023-2024 Spring | 2.66 | 2 sec · 98 öğr |
| 2022-2023 Fall | 2.68 | 2 sec · 138 öğr |
| 2022-2023 Spring | 2.80 | 2 sec · 96 öğr |
| 2021-2022 Fall | 2.66 | 2 sec · 136 öğr |
| 2021-2022 Spring | 2.69 | 2 sec · 84 öğr |
| 2020-2021 Fall | 2.74 | 3 sec · 168 öğr |
Aggregate course GPA — Bilkent STARS'tan public data. Hoca-bazlı per-section detayı için STARS evaluation report →. Öğrenci anket cevapları KVKK kapsamında defter'de tutulmaz.
In order to qualify for the Final Exam, the Midterm Exam grade must be at least 30 out of 100.
Introduction to Database Design - Entity-Relationship (ER) Model Relational Data Model Relational Algebra Relational Algebra SQL Query Language SQL Query Language Database Application Development Schema Refinement and Normal Forms Schema Refinement and Normal Forms Overview of Storage and Indexing Tree-Structured Indexing Hash-Based Indexing Overview of Transaction Management Concurrency Control ECTS - Workload Table: Activities Number Hours Workload Individual or group work 14 2 28 Preparation for Final exam 1 15 15 Laboratory (including preparation) 7 2 14 Course hours 14 3 42 Final exam 1 2 2 Homework 5 5 25 Project (including preparation and presentation if applicable) 1 15 15 Midterm exam 1 2 2 Preparation for Midterm exam 1 10 10 Total Workload: 153 Total Workload / 30: 153 / 30 5.1 ECTS Credits of the Course: 5 Type of Course: Laboratory Work - Lecture Course Material: PP - Written Teaching Methods: Assignment - Exercises - Lecture