Introdução às Bases de Dados

Pós-Graduação em Design Multimédia
4 ECTS; 1º Ano, 1º Semestre, 50,0 TP + 8,0 OT

Lecturer

Prerequisites
Not applicable

Objectives
1) Master the concepts associated with relational databases, 2) Understand the analysis and data normalization, 3) Acquire skills in the development of databases in Access, 4) Handle and search for information in databases of client-server architecture using SQL language.

Program
1) Relational Databases - Concepts, 2) Analysis and data normalization, 3) Development of databases in Access; 4) Structured Query Language - SQL; 5) Client-Server database - Microsoft SQL Server.

Evaluation Methodology
1) Evaluation Project (70%). Practical exercises (30%).

Bibliography
- Pereira, J. Tecnologia de Base de Dados. (Vol. 1). (pp. 522). Lisboa: FCA
- Damas, L. SQL - Structured Query Language. (Vol. 1). (pp. 448). Lisboa: FCA

Method of interaction
Practical and laboratory classes with solving practical cases.

Software used in class
Microsoft Access;
Microsoft SQL Server.