| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Database Management Systems | BSM 212 | 4 | 2 + 1 | 3 | 6 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | Lisans |
| Dersin Türü | Seçmeli |
| Dersin Koordinatörü | Doç.Dr. MEHMET FATİH DÖKER |
| Dersi Verenler | MEHMET ZEKİ İMAMOĞLU, |
| Dersin Yardımcıları | |
| Dersin Kategorisi | Diğer |
| Dersin Amacı | Information systems, GIS and its components, structure of database, design of database, and transferring data into GIS |
| Dersin İçeriği | Database: database management system; basic concepts and explanations about database; design of database: making rows and columns, independence of data in database; data models for database: relative existence model; line ordered design, network model and relational model; principles of relational database, design of relational database, structural query language on relational database and examples |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | They list advantages and disadvantages traditional file system structure, | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 2 | They recognize main concepts of databases | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 3 | They describe sub systems databases and data models | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 4 | They manage of designing database systems | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 5 | They create database by using MS Access DBMS program | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 6 | They create tables by using visual interfaces of MS Access, builds relationships amond tables created | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 7 | They enter data into tables, crates form pages for updating and deleting | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 8 | They create queries by using visual interfaces at MS Access | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 9 | They create macros in MS Access, changes the attributes of MS Access | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 10 | They create etables by SQL commands in MS Access | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 11 | They add record to the table, updates records, deletes records | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 12 | They carry out quering interactions by using SQL commands at MS Access | Lecture, Discussion, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Basic attributes 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 | Midterm exam | |
| 9 | Adding records by using data page mode, listing records, searching data in records, and creating form by means of wizard | |
| 10 | 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 | |
| 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 | To have advance-level information and comprehension which stay up with textbook that contain to current informations, practise equipments and other scientific contexts, able to use these ones | X | |||||
| 2 | To evaluate concepts, opinions and datas with scientific methods in geography and geographical information technology field.To determine to complicated problem and subjects, its able to analising, able to discuss, able to develop to suggestions which based upon to proof and research | X | |||||
| 3 | To instruct professional or beginner listener groups about subject associated with geography and geographical information technology.Able to transfer to the listeners of ideas,problems and solutions by oral and written examination | X | |||||
| 4 | Able to show administer advance-level working freely | X | |||||
| 5 | To discover solution methods on complicated conditions in practise in geography and geographical information technology field | X | |||||
| 6 | Able to administer thereby planning of activities directed towards professional evolution | X | |||||
| 7 | To know foreign language for able to communicate with colleauges and to follow up to informations on geography and geographical information technology field | ||||||
| 8 | Able to use of technologies of informatics and communication with knowledge of computer software and hardware | X | |||||
| 9 | To have satisfactoriness of looking after of social,scientific and ethic values on stages of data collection, explication and announced | X | |||||
| 10 | To have knowledge and consciousness of looking after of social,scientific and ethic values on stages of data collection, explication and announced | X | |||||
| 11 | Conscious about professional security, health, quality control and its management and environmental protection | X | |||||
| 12 | X | ||||||
| 13 | X | ||||||
| 14 | X | ||||||
| 15 | X | ||||||
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ara Sınav | 40 |
| 1. Kısa Sınav | 15 |
| 1. Ödev | 15 |
| 1. Performans Görevi (Laboratuvar) | 30 |
| Toplam | 100 |
| 1. Yıl İçinin Başarıya | 60 |
| 1. Final | 40 |
| 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 | 1 | 10 | 10 |
| Assignment | 1 | 10 | 10 |
| Toplam İş Yükü | 126 | ||
| Toplam İş Yükü / 25 (Saat) | 5,04 | ||
| Dersin AKTS Kredisi | 6 | ||