Fundamentos de Base de Dados

Tecnologias de Informação e Comunicação
5 ECTS; 2º Ano, 1º Semestre, 30,0 PL + 30,0 TP

Lecturer
- Henrique Carlos dos Santos Mora

Prerequisites
Not applicable.

Objectives
The students should learn the fundamentals of databases and related technologies and methodologies. At the end of the semester, they are expected to be able to develop, implement and monitor projects involving large databases.

Program
1. Basic concepts
2. Databases
3. Traditional design methods
4. Data access language for relational databases
5. Microsoft Sql Server

Evaluation Methodology
Student with Worker - Student status
Final work 100%
Student without Worker - Student status
Class participation 20%
Final work 80%

Bibliography
- Date, C. (2000). An Introduction to Database Systems. EUA: Addison-Wesley
- Mora, C. (2011). Sebenta de FBD. Portugal: IPT

Method of interaction
Lectures and tutorials.
Laboratory sessions involving problem solving and experimental demonstrations.

Software used in class
Microsoft SQLServer 2008 R2 or superior
Microsoft Visio 2010 or superior