| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Database Management Systems | BYP 209 | 3 | 2 + 1 | 3 | 5 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | Ön Lisans |
| Dersin Türü | Zorunlu |
| Dersin Koordinatörü | Öğr.Gör. FATİH ALBAYRAK |
| Dersi Verenler | Doç.Dr. OSMAN HAMDİ METE, |
| Dersin Yardımcıları | |
| Dersin Kategorisi | Diğer |
| Dersin Amacı | Development of database management systems(DBMS), basic concepts, DBMS application program(MS Access), visual interface and Structured Query Language(SQL), to have capability of creating, data processing, and searching of DBMS by using SQL |
| Dersin İçeriği | Traditional file systems, DBMS concepts, designing database, use of MS Access visual interface, designing tables, creating form, primary keys, relations, creating tables, entering, deleting, quering, and updating data by using SQL commands |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | To list advantages and disadvantages traditional file system structure, | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| 2 | To recognize main concepts of Databases | Discussion, Question-Answer, Self Study, Lecture, | Homework, Testing, |
| 3 | To describe sub systems Databases and data models | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| 4 | To manage of designing database systems | Discussion, Question-Answer, Self Study, Lecture, | Homework, Testing, |
| 5 | To Create database by using MS Access DBMS program | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| 6 | To Create tables by using visual interfaces of MS Access, builds relationships amond tables created | Discussion, Question-Answer, Self Study, Lecture, | Testing, Homework, |
| 7 | To Enter data into tables, crates form pages for updating and deleting | Lecture, Question-Answer, Self Study, Discussion, | Testing, Homework, |
| 8 | To Create queries by using visual interfaces at MS Access | Discussion, Question-Answer, Self Study, Lecture, | Testing, Homework, |
| 9 | To Create macros in MS Access, changes the attributes of MS Access | Lecture, Self Study, Question-Answer, Discussion, | Homework, Testing, |
| 10 | To Creat etables by SQL commands in MS Access | Discussion, Question-Answer, Self Study, Lecture, | Testing, Homework, |
| 11 | To add record to the table, updates records, deletes records. | Lecture, Self Study, Question-Answer, Discussion, | Homework, Testing, |
| 12 | To carry out quering interactions by using SQL commands at MS Access | Discussion, Self Study, Question-Answer, Lecture, | Testing, Homework, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Basic attibutes of traditional file systems, advantages and disadvantages, general structures of database systems and their characteristics | |
| 2 | Basic database concepts(table, field, and record), advantages of DBMS, Data Models, DB software, hardware infrastructure. | |
| 3 | designing of database, normalisation processings, point to be considered during design process, case study | |
| 4 | Installation of MS Access, usage of interface, creating database in MS Access environment | |
| 5 | Creating tables by using wizard in MS Access visual interface, definition of key (primary key, candidate key and foreign key) | |
| 6 | MS Access data types, creating tables in visual interface as desgn mode, field attributes, adding record to existent table, deleting field, and creating primary and candidate keys | |
| 7 | Relation among tables by using MS Access visual interface (one by one and multiple), arrangement and delete of existent relations | |
| 8 | Adding records by using data page mode, listing records, searching data in records, and creating form by means of wizard | |
| 9 | Creating query by using wizard in MS Access, creating query by using design mode, usage of constraints in query, adding and deleting of fields in query design screen | |
| 10 | Queries of adding, updating and deleting of records, activating of created queries | |
| 11 | Creating form in design mode, toolbox, adding object to form page, checking attributes of objects | |
| 12 | Creating macros in MS Access, adding macros to objects in form page, adding of starting form to MS Access application program | |
| 13 | Basic characterictics of SQL, creating table by SQL commands in Query screen of MS Access | |
| 14 | Adding record to the table, updating record, deleding record, and basic quering interactions by using SQL command in Query screen at MS Access |
| Kaynaklar | |
|---|---|
| Ders Notu | |
| Ders Kaynakları | |
| Sıra | Program Çıktıları | Katkı Düzeyi | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | X | ||||||
| 2 | X | ||||||
| 3 | |||||||
| 4 | X | ||||||
| 5 | |||||||
| 6 | |||||||
| 7 | |||||||
| 8 | |||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ara Sınav | 50 |
| 1. Kısa Sınav | 15 |
| 1. Ödev | 20 |
| 2. Kısa Sınav | 15 |
| Toplam | 100 |
| 1. Yıl İçinin Başarıya | 20 |
| 1. Final | 80 |
| 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 | 3 | 48 |
| Mid-terms | 1 | 10 | 10 |
| Quiz | 2 | 5 | 10 |
| Assignment | 1 | 10 | 10 |
| Final examination | 1 | 10 | 10 |
| Toplam İş Yükü | 136 | ||
| Toplam İş Yükü / 25 (Saat) | 5,44 | ||
| Dersin AKTS Kredisi | 5 | ||