Bases de Dados

TeSP - Tecnologia e Programação em Sistemas de Informação
6 ECTS; 2º Ano, 1º Semestre, 30,0 T + 45,0 PL + 7,50 OT

Lecturer
- António Casimiro Teixeira Batista

Prerequisites

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

Bibliography
- Gouveia, F. (2014). Fundamentos de Bases de Dados. Lisboa: FCA - Editora de Informática
- Baptista, A. (2012). Apontamentos e material de apoio. Tomar: Autor

Method of interaction

Software used in class