Basic skills in programming.
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.
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.
Pedro Henrique e Figueiredo Quaresma de Almeida
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.