IPT Logotipo do IPT

Ano Letivo: 2013/14

Engenharia Informática

Databases I

<< back to Curriculum Plan

Publication in the Diário da República: Despacho n.º16228/2009 - 15/07/2009

6 ECTS; 2º Ano, 1º Semestre, 28,0 T + 42,0 PL + 5,0 OT + 5,0 O , Cód. 911915.

Lecturer
- António Casimiro Teixeira Batista (2)
- José Casimiro Nunes Pereira (2)

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

Prerequisites
Not applicable.

Objectives
An introduction to the theory and
practice of DBMS. The emphasis will be on theoretical considerations about modelling data and designing easy to use
and effective DB systems. The students will learn concepts such as Database, Data Structure, Data Modeling and SQL.

Program
1 - Objectives and functions of DBMS.
2 - Ancient data models. Relational model.
3 - Relationships. Data dictionary. Keys.Primary key, foreign key and indices. Integrity and rules.
4-Functional dependencies and normalization. First normal form
(1FN), second normal form (2FN), third normal form (3FN) and
Boyce-Codd normal form.
5-Entity-relationship method. Extended E-R.
6 - SQL.

Evaluation Methodology
Written Test. Laboratory coursework. Preparation and presentation of a Final Project.

Bibliography
- Batista, A. (2012). Apontamentos e material de apoio. Tomar: Autor
- Pereira, J. (1999). Tecnologia de Bases de Dados. Lisboa: Lidel/FCA - Editora de Informática

Teaching Method
Lectures, tutorials and laboratory classes.

Software used in class

 

 

 


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