Modeling of problems for implementation in a Database.Knowledge of the technical tools provided by a Database.
Generic competences:Competence in using computational tools;
Capacity for generalization and abstraction;Capacity for formulating and solving problems;
Conception or use of mathematical models in real situations;Logical argumentation;
Use of Internet as a communication tool and a source of information;Capacity for teamwork;
Imagination and creativity.
Fundamental concepts of a Data Base Management Systems.
Levels of abstraction.
The Entity model - Association.
The relational model.
The SQL language.
Integrity and Security.
Functional dependencies and normalization.
Computers and programming
Generic skills to reach
. Competence in organization and planning; . Knowledge of a foreign language; . Computer Skills for the scope of the study; . Competence in information management; . Competence in working in interdisciplinary teams; . Competence to solve problems; . Capacity of decision; . Critical thinking; (by decreasing order of importance)
Teaching hours per semester
total of teaching hours
assessment implementation in 20142015 Assessment Project: 30.0% Exam: 70.0%
Bibliography of reference
SILBERSCHATZ, KORTH, and SUDARSHAN. Database System Concepts. Mc Graw Hill.
DAMAS, Luís. (2005). SQL. FCA.
NEVES, Pedro e RUAS, Rui. (2005). O Guia Prática do MySQL. Centro Atlantico.