Databases

Year
0
Academic year
2018-2019
Code
01001330
Subject Area
Área Científica do Menor
Language of Instruction
Portuguese
Mode of Delivery
Face-to-face
Duration
SEMESTRIAL
ECTS Credits
6.0
Type
Elective
Level
1st Cycle Studies

Recommended Prerequisites

Basic skills in programming.

Teaching Methods

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.

Learning Outcomes

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.

Work Placement(s)

No

Syllabus

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.

Head Lecturer(s)

Pedro Henrique e Figueiredo Quaresma de Almeida

Assessment Methods

Assessment
Project: 30.0%
Frequency: 70.0%

Bibliography

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.