Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems BSM 212 4 2 + 1 3 6
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator Doç.Dr. MEHMET FATİH DÖKER
Course Lecturers
Course Assistants
Course Category
Course Objective Information systems, GIS and its components, structure of database, design of database, and transferring data into GIS
Course Content 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
# Course Learning Outcomes Teaching Methods Assessment Methods
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,
Week Course Topics Preliminary Preparation
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
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
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
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 40
1. Kısa Sınav 15
1. Ödev 15
1. Performans Görevi (Laboratuvar) 30
Total 100
1. Yıl İçinin Başarıya 60
1. Final 40
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
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
Total Workload 126
Total Workload / 25 (Hours) 5.04
dersAKTSKredisi 6