Relational Databases

Code:

MSIGOT025

Acronym:

BDR

Keywords
Classification	Keyword
OFICIAL	Database Management

Instance: 2023/2024 - 1S

Active?	Yes
Responsible unit:	Department of Geography
Course/CS Responsible:	Masters in Geographical Information Systems and Spatial Planning

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MSIGOT	30	MSIGOT - Study Plan	1	-	6	54	162

Teaching language

Suitable for English-speaking students

Objectives

Masters in GIS and Spatial Planning must devellop projects of relational databases, the supporting technology of current GIS solutions.
The geographic data comprises alphanumeric data, in common to relational databases, but also a spatial component.
In this sense, the program focuses on the design of relational databases, with a strong focus on conceptual modelling of problematic situations, its conversion to the relational model with an awareness of its normalization.
Additionally, the geographic data components are analysed, together with spatial extensions to relational databases. The differences to the project of a database for GIS are also described.

Learning outcomes and competences

At the end of the course, the student should be able to design a database for a GIS. More specifically, the student will be able to:
- Identify the fundamentals of relational databases and database management systems;
- Create the conceptual model of a relational database;
- Develop the logical model of a relational database, taking into account aspects related to normalization;
- To coordinate the construction of a geographic database using a GIS or spatial database;
- To conduct analysis through the use of the SQL language.

Working method

Presencial

Program

1 - Introduction to relational databases.
2 - Conceptual modelling. UML - Unified Modeling Language
3 - Relational databases. Conversion of the conceptual  model to the relational model.
4 - Normalization.
5 - Interrogation languages for databases.
6 - Geographic data models. Project of geographical databases. Databases for GIS.
7 - Spatial databases. Spatial extensions to data manipulation languages.

Mandatory literature

Borges, J. L.; Galvão Dias, T.; Falcão e Cunha, J. ; Modelação de Dados em UML, FCA, 2015. ISBN: 978-972-722-812-6
Caldeira, Carlos Pampulim ; PostgreSQL - Guia Fundamental, Edições Sílabo, 2015. ISBN: 9789726187950
Date, C.; Introdução a Sistemas de Bancos de Dados, Editora Campus , 2003
Gouveia, Feliz ; Bases de Dados - Fundamentos e Aplicações, FCA, 2021. ISBN: 9789727229017
Rigaux, P.; Scholl, M.; Voisard, A.; Spatial Databases: With Application to GIS, Morgan Kaufmann, 2001
Shekhar, Shashi; Chawla, Sanjay ; Spatial Databases: A Tour 1st Edition, Prentice Hall., 2003. ISBN: 978-0130174802
Ulmman, J.; Widom, J.; First Course in Database Systems., Pearson Education Limited, 2013. ISBN: 9781292038247

Teaching methods and learning activities

Classes are TP, with an exhibition of some key issues, which are developed through case studies and problem solving, as well as the use of tutorials. At the end of the semester students develop practical work in groups with tutorial. At the end of the semester students develop a practical assignment, in groups, under the supervision of the teachong staff.

Software

ArcGis Pro
ArcGis 10.8
PostgresSQL 10.4
Visual Paradigm Community Edition
Quantum Gis
PgAdmin

keywords

Technological sciences

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Designation	Weight (%)
Teste	40,00
Trabalho escrito	50,00
Apresentação/discussão de um trabalho científico	10,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	78,00
Frequência das aulas	54,00
Trabalho de investigação	30,00
Total:	162,00

Eligibility for exams

Mandatory attendance of 75% of classes.

Calculation formula of final grade

Evaluation:
Written test - 40%
Practical Work - 50%
Presentation - 10%
Classification: 0,4*WT+0,5*PW+0,1*P

Examinations or Special Assignments

To be established with the students in the 1st class.

Classification improvement

To be established with the students in the 1st class.