Database modeling of large scale information problems. Knowledge of tools and technics to implement and maintain a database system.
The main competencies to be developed are: skills in computational tools; generalisation and abstraction; be able to formulate an solve new problems; implementation of mathematical models in real live situations; logical reasoning; team work; personal initiative; use of the Internet as a source of information; imagination and creativity.
Fundamental concepts about the DBMSs.
Levels of abstraction and the Entity-Relationship Model. The Relational Model.
The SQL language.
Normalization. Security and integrity of the databases.
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 20182019 Assessment Project: 30.0% Exam: 70.0%
Bibliography of reference
A. Silberschatz, H. Korth, S. Sudarshan, Database System Concepts, sexta edição, McGraw-Hill, 2010.
J.L.M. Pereira, Tecnologia de Bases de Dados, 3ª Edição, FCA-Ed.Informatica, 1998.
Two types of classes: expository style with examples and exercises to apply the material being taught. Computational Laboratory: with practice of an DBMS implementing databases problems in a relational database.