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