You need to activate javascript for this site.
Menu Conteúdo Rodapé
  1. Home
  2. Courses
  3. Geographic Information Systems
  4. Spatial Databases

Spatial Databases

Code 16645
Year 1
Semester S1
ECTS Credits 7,5
Workload T(15H)/TP(15H)
Scientific area Sistemas de Informação Geográfica
Entry requirements Skills on programming and algorithms.
Mode of delivery Face-to-face (practical and laboratory classes)
Work placements Not applicable
Learning outcomes This course introduces the theme of design, analysis and construction of the relational databases. Therefore, its main objective is to prepare students to understand and design database systems.
The course focuses on the relational model, namely, the conceptual model and database querying.
Upon completion of the teaching-learning process, the student should be able to:
- Given a real or hypothetical case, develop a suitable data model (Entity-Relationship Diagram and relational schema);
- Normalize and "de-normalize" relations;
- Produce the physical database model;
- Query the database (using SQL);
- Explore databases (employing forms and reports);
- Use data modulation in the context of geographical data systems (Geodatabases).
Syllabus 1. Introduction to database systems
1.1 Traditional data files vs Desktop databases vs Client/server databases: advantages, disadvantages and when
use (or not use)
1.2 Fundamental concepts
1.3 Data models
2. The relational model
2.1 The data model
2.2 Database query language (SQL)
2.3 Integrity constraints
3. Conceptual database design
3.1 Entity-Relationship modelling
3.2 Normalization
4. Applications development using SQL Server.
5. Open Street Map
5.1 Introduction to OSM
5.2 OSM and Databases
6. Postgres + Postgis and QGIS
Main Bibliography 1. Thomas Connolly and Carolyn Begg, “Database Systems, A Pratical Approach to Design, Implementation and
Management”, 6th Edition, 2015. Pearson, ISBN: 978-1-292-06118-4.
2. Feliz Gouveia, “Fundamentos de Bases de Dados”, 2014, FCA-Editora de Informática; ISBN: 978-972-722-799-0.
3) Luís Damas, “SQL – Structured Query Language”, 6ª Edição, FCA, 2005 (ISBN 978-972-722-443-2).
4) Frederik Ramm, “OpenStreetMap: Using and Enhancing the Free Map of the World”, 2010, UIT Cambridge, ISMN:
5) C. J. Date. “An Introduction to Database Systems”. Addison-Wesley, 8th Edition, 2003 (ISBN: 978-0321197849).
6) J. Hoffer, M. Prescott, F. McFadden. “Modern Database Management”. 11th Edition, 2012, Prentice Hall (ISBN:
7) Abraham Silberschatz, Henry Korth, S. Sudarshan. “Database System Concepts”, 6th Edition , 2010, McGraw-Hill
(ISBN: 978-0-07-352332-3)
Teaching Methodologies and Assessment Criteria Classes are organized to present the syllabus (through slides and/or oral presentation),
encouraging student interaction in order to allow the exploration of concrete scenarios for using databases (Postgres).
These PL classes (practical and laboratory teaching) are also aimed at carrying out practical work.
Practical work is carried out in groups (2 students, preferably).
The assessment comprises two components:
- Written part (10 points)
- Practical work (10 points)
Language Portuguese. Tutorial support is available in English.
Last updated on: 2024-01-19

The cookies used in this website do not collect personal information that helps to identify you. By continuing you agree to the cookie policy.