Bases de Dados II

Engenharia Informática
6 ECTS; 2º Ano, 2º Semestre, 28,0 T + 42,0 PL + 5,0 OT + 5,0 O

Lecturer
- António Casimiro Teixeira Batista
- José Casimiro Nunes Pereira

Prerequisites
Databases I

Objectives
Students should acquire an understanding of database technology and become familiar with the development of database applications and the administration of multi-user databases.

Program
1 – An introduction to the administration of Database Management
Systems.
2 – Physical and logical administration of Database Management
Systems.
3 – Competition and transactions.
4 – Security and recovery
5 - Query optimization.

Evaluation Methodology
Theoretical test and laboratory coursework.

Bibliography
- Date, C. (2003). An Introduction to Database Systems. .: Addison Wesley
- Pereira, J. e Batista, A. (2012). Apontamentos e material de apoio. Tomar: Autor
- Navathe, S. e Elmasri, R. (2010). Fundamentals of Database Systems. .: Addison Wesley
- Gouveia, F. (2014). Fundamamentos de Bases de Dados. (Vol. 1). Lisboa: FCA - Editora de Informática, Lda

Method of interaction
Lectures, tutorials and laboratory classes.

Software used in class
MySQL
MySQL Workbench