| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Database Management Systems | ISE 305 | 5 | 3 + 0 | 3 | 5 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | Lisans |
| Dersin Türü | Zorunlu |
| Dersin Koordinatörü | Dr.Öğr.Üyesi MUHAMMED KOTAN |
| Dersi Verenler | Dr.Öğr.Üyesi MUHAMMED KOTAN, |
| Dersin Yardımcıları | |
| Dersin Kategorisi | Diğer |
| Dersin Amacı | As computers becoming indispensable parts of our lives, data and databases gathers more importance everyday. The main goal of the course is to teach the basics of database(data storage), how to use, design and make sample applications. |
| Dersin İçeriği | Definitions and basic concepts, entity-relation model, Relational Data Model, Relational Algebra and Calculation, Structural Query Language, Functional dependence and normalization, Transaction Management, Synchronism Control, Database Recovery, Database Security, Object Oriented Database, Database Programming and Internet Applications, Data Warehouse and Data Mining |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | Recognizes database management systems | Lecture, Drilland Practice, Role Playing, | Testing, Homework, |
| 2 | Makes the models of database with entity-relation diagrams. | Lecture, Drilland Practice, Role Playing, Project Based Learning, | Testing, Homework, |
| 3 | Query databases with SQL | Lecture, Question-Answer, Drilland Practice, Project Based Learning, | Testing, Homework, |
| 4 | Understands database normalization steps | Lecture, Drilland Practice, Role Playing, Project Based Learning, | Testing, Project / Design, |
| 5 | Lecture, Drilland Practice, Role Playing, Project Based Learning, | Testing, Project / Design, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Introduction to Database Management Systems | |
| 2 | Entity-relation model | |
| 3 | Relational Data Model | |
| 4 | Relational Algebra and Calculation | |
| 5 | SQL | |
| 6 | SQL | |
| 7 | SQL | |
| 8 | Normalization | |
| 9 | Database Management System | |
| 10 | Database Management System | |
| 11 | Database Management System | |
| 12 | Web Database Applications | |
| 13 | Web Database Applications | |
| 14 | Web Database Applications |
| Kaynaklar | |
|---|---|
| Ders Notu | Ramakrishnan . Gehrke,Database Management Systems, Third Edition, McGraw-Hill,2003. |
| Ders Kaynakları | 1.Yarımağan, Ü.,Veritabanı Sistemleri, Ankara, 2000. 2. C. J. Date, "An Introduction to Database Systems", Eight Edition, Addison-Wesley, 2004. |
| Sıra | Program Çıktıları | Katkı Düzeyi | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | X | ||||||
| 2 | X | ||||||
| 3 | X | ||||||
| 4 | X | ||||||
| 5 | X | ||||||
| 6 | |||||||
| 7 | X | ||||||
| 8 | |||||||
| 9 | X | ||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ara Sınav | 50 |
| 1. Kısa Sınav | 20 |
| 1. Ödev | 15 |
| 2. Ödev | 15 |
| Toplam | 100 |
| 1. Yıl İçinin Başarıya | 40 |
| 1. Final | 60 |
| Toplam | 100 |
| AKTS - İş Yükü Etkinlik | Sayı | Süre (Saat) | Toplam İş Yükü (Saat) |
|---|---|---|---|
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 4 | 64 |
| Mid-terms | 1 | 5 | 5 |
| Quiz | 1 | 5 | 5 |
| Assignment | 2 | 5 | 10 |
| Final examination | 1 | 15 | 15 |
| Toplam İş Yükü | 147 | ||
| Toplam İş Yükü / 25 (Saat) | 5,88 | ||
| Dersin AKTS Kredisi | 5 | ||