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)
- Ana Carla Vicente Vieira (2)
- Fernando Sérgio Hortas Rodrigues (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
