IPT Logotipo do IPT

Ano Letivo: 2013/14

Sistemas de Informação Geográfica, em Planeamento e Gestão do Território

Geographic Databases

<< back to Curriculum Plan

6 ECTS; 1º Ano, 1º Semestre, 45,0 TP , Cód. 30181.

Lecturer

(1) Docente Responsável
(2) Docente que lecciona

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

Teaching Method
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

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado