Relational Databases

Code:

MSIGOT025

Acronym:

BDR

Keywords
Classification	Keyword
OFICIAL	Database Management

Instance: 2013/2014 - 1S

Active?	Yes
Responsible unit:	Department of Geography
Course/CS Responsible:	Masters in Geographical Information Systems and Spatial Planning

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MSIGOT	29	MSIGOT - Study Plan	1	-	6	54	162

Teaching language

Portuguese

Objectives

To understand the concepts of databases and database management systems. To undertake the conceptual modelling of a relational database system. To identify entities, attributes and relationship types and represent them on an entity-relationship diagram To build a geographic database and explore some SQL language tools.

Learning outcomes and competences

To understand the concepts of databases and database management systems. To undertake the conceptual modelling of a relational database system. To identify entities, attributes and relationship types and represent them on an entity-relationship diagram To build a geographic database and explore some SQL language tools.

Working method

Presencial

Program

1. Database 1.1 Database management systems - DBMS 2. Data modelling 2.1 Graphic data Definition of layers 2.2 Tabular data 3. Levels of abstraction in a database 3.1 Reality 3.2 Conceptual model 3.3 Logical model 3.4 Physical model 4. Structures of non-graphic data 4.1 Network model 4.2 Hierarchical model 4.3 Relational model Entities Relationships: cardinality Attributes: identifiers and descriptors Primary keys and foreign keys Entity-relationship diagram - ERD Integrity rules Normalisation 4.4 Object-oriented model Class and object Specialisation Aggregation Encapsulation 5. Translation of ERD into a data structure diagram – DSD 6. SQL language 6.1 Practical exercises

Mandatory literature

Ullman, Jeffrey D; A First Course in Database Systems. ISBN: 0-13-861337-0

Teaching methods and learning activities

Theory and practical classes

Software

ArcView
Geomedia
UDIG
PostGres
Acess

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Teste	50,00
Trabalho escrito	50,00
Total:	100,00

Eligibility for exams

Mandatory attendance of 75% of classes.

Calculation formula of final grade

To be established with the students in the 1st class.