Yazdır

Ders Tanımı

Ders 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ü SECMELI
Dersin Koordinatörü Dr.Öğr.Üyesi MEHMET FATİH DÖKER
Dersi Verenler
Dersin Yardımcıları
Dersin Kategorisi
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
Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 - They list advantages and disadvantages traditional file system structure, 1 - 3 - 4 - 6 - A - C - D -
2 - They recognize main concepts of databases 1 - 3 - 4 - 6 - A - C - D -
3 - They describe sub systems databases and data models 1 - 3 - 4 - 6 - A - C - D -
4 - They manage of designing database systems 1 - 3 - 4 - 6 - A - C - D -
5 - They create database by using MS Access DBMS program 1 - 3 - 4 - 6 - A - C - D -
6 - They create tables by using visual interfaces of MS Access, builds relationships amond tables created 1 - 3 - 4 - 6 - A - C - D -
7 - They enter data into tables, crates form pages for updating and deleting 1 - 3 - 4 - 6 - A - C - D -
8 - They create queries by using visual interfaces at MS Access 1 - 3 - 4 - 6 - A - C - D -
9 - They create macros in MS Access, changes the attributes of MS Access 1 - 3 - 4 - 6 - A - C - D -
10 - They create etables by SQL commands in MS Access 1 - 3 - 4 - 6 - A - C - D -
11 - They add record to the table, updates records, deletes records 1 - 3 - 4 - 6 - A - C - D -
12 - They carry out quering interactions by using SQL commands at MS Access 1 - 3 - 4 - 6 - A - C - D -
Öğretim Yöntemleri: 1:Lecture 3:Discussion 4:Drilland Practice 6:Motivations to Show
Ölçme Yöntemleri: A:Testing C:Homework D:Project / Design

Ders Akışı

Hafta Konular ÖnHazı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ı

Döküman Paylaşımı


Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çı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

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 40
KisaSinav 1 15
Odev 1 15
PerformanGoreviLabaratuvar 1 30
Toplam 100
Yıliçinin Başarıya Oranı 60
Finalin Başarıya Oranı 40
Toplam 100

AKTS - İş Yükü

Etkinlik Sayısı Süresi(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(s) 5.04
Dersin AKTS Kredisi 5.04
; ;