6 ECTS; 1º Ano, 1º Semestre, 45,0 TP , Cód. 30181.
Lecturer
- Rita Ribeiro de Carvalho Ferreira Anastácio (2)
(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 databases.
2. Database Management Systems (DBMS) and data models.
3. Relational Model: Concepts; Types of relationship; Normalization; E-R Diagram
4. Microsoft Access (MS Access): Tables, fields, and records. Definition of relations. E-R consistency tests.
5. Geographic Data Model in ArcGIS: Geodatabase
6. Construction and management of a geodatabase: Concept and properties; Elements and organization; Types of geodatabase; Steps and processes of construction; Conception and validation of the relational model in MS Access
7. Creation and import of information.
8. Creating and Editing Tables
9. Behavior of the entities of a geodatabase: Definition of Domains; Establishment of Subtypes; Relationship Establishment; Geometric Networks
10. Data query in ArcGis: Introduction to the SQL language; Querying a geodatabase through the SQL-based Query Builder (ArcGIS) interface
Evaluation Methodology
Practical work for all evaluation data.
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
