IPT Logotipo do IPT

Ano Letivo: 2020/21

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 (1)(2)

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

Prerequisites
Not applicable.

Objectives

Program
1. Introduction.
1.1 Importance and influence of Databases in modern world.
1.2 Role of DBMS.
1.3 Data Abstraction.
1.4 Data models.
1.5 Instances and schemes.
1.6 Data independence.
1.7 Data definition language (DDL) e Data manipulation language (DML).
1.8 SQL.
1.9 Database manager.
1.10 Database Administrator.
1.11 Overall structure of the system.

2. 1st generation models.
2.1 Hierarchical Model.
2.1.1 Basic concepts.
2.1.2 Tree structure.
2.1.3 Data manipulation.
2.1.4 Virtual segments.
2.2 Network Model.
2.2.1 Basic concepts.
2.2.2 Structure.
2.2.3 Data manipulation.


3. 2nd generation models. Relational data model.
3.1 Basic concepts.
3.2 Relationships.
3.3 Schemas.
3.4 Keys.
3.5 Data Dictionary.
3.6 Relational integrity.

4. Database design. Functional dependencies and normalization.
4.1 Functional dependencies.
4.2 Redundancy.
4.3 Normalization.
4.3.1 1st Normal Form.
4.3.2 Abnormalities.
4.3.3 2nd Normal Form.
4.3.4 3rd Normal Form.
4.3.5 Boyce-Codd Normal Form (BCNF).
4.4 Inference rules.
4.5 Decomposition Strategies using functional dependencies.

5. Database design. Entity-Relationship method (E-R).
5.1 Basic concepts.
5.2 E-R Diagram.
5.3 Occurrence Diagram.
5.4 Optional and mandatory participation.
5.5 Relationship Degrees.
5.6 Converting ER Diagrams to Tables.
5.7 Multiple binary relationships.
5.8 Higher order relationship types.

6. Relational Query Languages: SQL.
6.1 Relational Operations.
6.2 SQL commands.
6.3 DDL.
6.4 DML.

Evaluation Methodology
Written Test (85%).
Laboratory coursework (15%).
Mandatory Attendance of 2/3 of practical classes.

Bibliography
- Batista, A. (2012). Apontamentos e material de apoio. Tomar: Autor
- Date, C. (2004). Database Systems. New York: Pearson Addison Wesley
- Gouveia, F. (2014). Fundamentos de Base de Dados. Lisboa: FCA - Editora de Informática, Lda
- 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
b-on
santander
erasmus
catedra
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado