PT|EN
Fundamentals of Databases
Courses Degree in Informatics Engineering | Degree in Mathematics Applied to Management
Cod: 21053
Department: DCET
ECTS: 6
Scientific area: Computer Engineering
Total working hours: 156
Total contact time: 26

Relational databases are the core in information systems. Issues such as referential integrity in data entry, data models and development of queries and sub-queries are studied in this course.

1. database
2. relational model
3. entity- relation model
4. SQL - structure query language

Recognize the role and importance of databases in the broader context of information systems;
 
Identify key techniques, methodologies and tools databases, namely queries, data manipulation, data models development and theory of relational databases;
Apply databases techniques to implement computational solutions in order to solve problems of medium complexity

Database management systems (DBMS)
Structured Query Language and Relational Algebra
Entity-Relationship Model and Normal Forms
Database Design

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
 

E-learning.

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