This course allows you to explore theoretical and practical concepts of geographical databases. That includes design, implementation and usage of geographical databases. The course starts with general database terminologies such as DBMS, SQL, ACID, etc. Then it concentrates on steps for design and implementation of a database. This includes:
- requirement analysis
- conceptual modelling
- internal modelling and physical implementation
You will learn about database modelling using UML, how to create tables from UML, how to normalize tables, how to create tables in a DBMS, as well as indexing techniques. In addition, you learn Structured Query Language (SQL) for creating and managing databases, as well as 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.
Teaching consists of lectures and practical exercises that you submit to your teachers. The course ends with a written exam.
Please note that this is an internet based course. You do not need to visit Lund physically in order to attend. Also note that this course can only be taken as part of the iGEON master program.
Course facts: GISN06
Credits: 7.5 ECTS
Language of instruction: English
Prerequisites: General admission requirements and 90 ECTS, including 30 ECTS in GIS, equivalent to GISA21 and GISA22
Technical prerequisites: PC with Windows 7 or better; Internet connection