Cod: 21103
Department: DCET
Scientific area: Computer Engineering
Total working hours: 156
Total contact time: 26

The management systems of relational databases are of the utmost importance in the information systems. The problems of storage, optimization of consultation, competitive system and modeling of "data warehousing" are developed in this curricular unit.

Recognizing the role and importance of databases in the most general context of information systems;
Identify the main techniques, methodologies and tools of databases, notably in storage and consultation, transactional system Management and the development of data warehouses.
Apply databases techniques to implement computational solutions to resolve issues of medium complexity.

Databases Management systems (DBMS)
Storage and Queries
Transactional System Management
"Data Warehousing" and "Information Retrieval"

Database System Concepts, Abraham Silberschatz, Henry Korth, S. Sudarshan, McGraw-Hill Science/Engineering/Math,  ISBN-10: 0073523321
Fundamentos de Bases de Dados, Feliz Gouveia, FCA – Editora de Informática, ISBN: 978-972-722-799-0


Continuous assessment is privileged: 2 or 3 digital written documents (e-folios) during the semester (40%) and a presence-based final exam (p-folio) in the end of the semester (60%). In due time, students can alternatively choose to perform one final presence-based exam (100%).

Prerequisites: UC 21053 Database Basics