Geographic Databases

Master of Geographic Information Systems in Planning and Territory Management
6 ECTS; 1º Ano, 1º Semestre, 45,0 TP

Lecturer

Prerequisites
Not apply

Objectives
Students should be able to define the architecture for the information system of a particular case and define its entity-association model, as well as the corresponding relational data model. Within the framework of this model, students should build a geodatabase and query this database.

Program
1. Introduction to DB. Normalization. EA and relational data models
2. MS Access: Tables, fields and records. Relationships
3. Geodatabases: Building process, properties and structure. Adding information. Creating and editing tables. Defining domains, sub-types and relationships. Geometric networks
4. Accessing data: introduction to SQL; querying a geodatabase using the Query Builder

Evaluation Methodology
Pratical report.

Bibliography
- Arctur, D. e Zeiler, Z. (2004). Designing Geodatabases: case studies in GIS data modeling.. USA: ESRI Press
- Maidment, D. (2002). Arc Hydro: GIS for water resources.. USA: ESRI Press
- Ramakrishnan, R. e Gehrke, J. (2003). Database Management Systems. Boston, USA: McGraw-Hill
- Zeiler, M. (2010). Modeling Our World: The ESRI Guide to Geodatabase Concepts.. Redlands, USA: ESRI Press

Method of interaction
Presencial. The presentation of the various topics will be complemented by its practical application by students who work in-person on the GIS platform adopted positions and may use special software licenses to study outside of class

Software used in class
ArcGis. Access