Databases

Year
3

Academic year
2022-2023

Code
01001330

Subject Area
Computation

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)

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 Nuno San-Bento Furtado

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.