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 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%).