Publication in the Diário da República: Despacho n.º 8644/2020 - 08/09/2020
5 ECTS; 2º Ano, 1º Semestre, 28,0 PL + 28,0 TP , Cód. 911937.
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
At the end of the course, students should be able to:
(1)- describe the database organization models (relational, networks, relational);
(2)- describe the fundamentals of modeling relational databases;
(3)- design databases through the analysis of functional dependencies and normalization;
(4)- design databases using the entity-relationship method;
(5)- execute SQL data structure definition commands (LDD commands)
(6)- execute SLQ commands to query and manipulate data from a database (LMD commands)
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
MySQL 5.6, 5.7 ou 8.0
PHP MyAdmin
MySQL Workbench
