In this course, students will explore theoretical and practical concepts of geographical databases including design, implementation and usage of geographical databases. The course starts with general database terminologies including database, DBMS, SQL, ACID, etc. Then it concentrates on steps for design and implementation of a database including requirement analysis, conceptual modelling, internal modelling and physical implementation. Students will study about database modelling using UML, how to create tables from UML, how to normalize the tables, how to create them in a DBMS and also indexing techniques. In addition they learn Structured Query Language (SQL) for creating and managing databases and also retrieving data from databases. Finally the course focuses on geographical databases including techniques for managing spatial data in a database, Spatial SQL and indexing techniques in geographical databases.

Note: this is an Internet based course. You are not supposed to travel to Lund to attend. The course is part of LUMA-GIS, the master program in GIS, but it is also possible to study this course outside the program. You can read more about the master program, the admission requirements and other rules and regulations on the homepage of LUMA-GIS.

Teaching consists of lectures and practical exercises that you will submit to the teachers. The course ends with a written exam.