IPT Logotipo do IPT

Ano Letivo: 2020/21

Tecnologia e Programação em Sistemas de Informação

Databases

<< back to Curriculum Plan

Publication in the Diário da República: Aviso nº 909/2016 - 27/01/2016

6 ECTS; 2º Ano, 1º Semestre, 30,0 T + 52,50 PL , Cód. 602416.

Lecturer
- António Casimiro Teixeira Batista (1)(2)

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

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
- Batista, C. e Pereira, C. (2012). Material de apoio às aulas. Tomar: -
- Gouveia, F. (2021). Bases de Dados - Fundamentos e Aplicações, 2ª Ed.. Portugal: FCA - Editora de Informática
- Microsoft, . (0). Transact-SQL. Acedido em 1 de janeiro de 2021 em https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15
- Ramakrishnan, . e Gehrke, J. (2002). Database Management Systems, 3rd Ed.. USA: McGraw-Hill
- Rodrigues, S. (2021). Material de apoio às aulas. Tomar: -

Teaching Method

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
Compete 2030
co-financiado