Fundamentos de Bases de Dados
Cod: 21053
Department: DCET
Department: DCET
ECTS: 6
Scientific area: Computer Engineering
Scientific area: Computer Engineering
Total working hours: 156
Total contact time: 26
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
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
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
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
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%).