COURSE UNIT TITLE

: DATABASE MANAGEMENT SYSTEMS FOR GIS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
GIS 5040 DATABASE MANAGEMENT SYSTEMS FOR GIS ELECTIVE 2 0 0 7

Offered By

Graduate School of Natural and Applied Sciences

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

PROFESSOR DOCTOR ALI GÜL

Offered to

GEOGRAPHICAL INFORMATION SYSTEMS (ENGLISH)
Geographical Information Systems (Non-Thesis) (English)
GEOGRAPHIC INFORMATION SYSTEMS (ENGLISH)
GEOGRAPHICAL INFORMATION SYSTEMS - NON THESIS (EVENING PROGRAM) (ENGLISH)

Course Objective

In this course both theory and practical solutions are treated. Basic understanding of databases and relational data management is necessary when evaluating different alternatives. Theory includes the basics of data bases and relational DBMSs, special features of spatial data as well as specialities of GIS applications and processing which affects the data requirements. A special emphasis is on database design process using conceptual modeling. Object-oriented approach, standards for spatial data and platforms for distributed geo-processing are introduced. Some commercial solutions are presented as examples and the students perform an exercise work on database design and implementation.

Learning Outcomes of the Course Unit

1   basic understanding of databases and relational data management
2   the basics of data bases and relational DBMSs
3   database design process using conceptual modeling
4   object-oriented approach, standards for spatial data and platforms for distributed geo-processing

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Introduction to Databases and Basic Concepts
2 Hierarchical Databases
3 Network Databases
4 Relational Databases
5 Relational Databases
6 Relational Design
7 Relational Design
8 Security, Integrity, views, concurrency, recovery
9 Security, Integrity, views, concurrency, recovery
10 Spatial Databases
11 Spatial Databases
12 Spatial database application
13 Spatial database application
14 Spatial database application

Recomended or Required Reading

OZKARAHAN, Esen, DATABASE MANAGEMENT: Concepts, Design, and Practice, Prentice-Hall Inc. Englewood Cliffs, N.J., 1990. ISBN 0-13-46812-4;

Planned Learning Activities and Teaching Methods

Assignments
Exams

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 ASG ASSIGNMENT
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.25 + ASG *0.25 +FIN *0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.25 + ASG *0.25 +RST *0.50


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

English

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

To be announced.

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 2 28
Preparation for midterm exam 1 30 30
Preparing assignments 1 30 30
Preparations before/after weekly lectures 14 4 56
Preparation for final exam 1 30 30
Midterm 1 2 2
Final 1 2 2
TOTAL WORKLOAD (hours) 178

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.132332323
LO.223223222322
LO.33232332
LO.432323232323