IPT Logotipo do IPT

Design Multimédia

<< back to Curriculum Plan

4 ECTS; 1º Ano, 1º Semestre, 50,0 TP + 8,0 OT , Cód. 20095.

Lecturer

(1) Docente Responsável
(2) Docente que lecciona

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
- Damas, L. SQL - Structured Query Language. (Vol. 1). (pp. 448). Lisboa: FCA
- Pereira, J. Tecnologia de Base de Dados. (Vol. 1). (pp. 522). Lisboa: FCA

Teaching Method
Practical and laboratory classes with solving practical cases.

Software used in class
Microsoft Access;
Microsoft SQL Server.

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
b-on
santander
erasmus
catedra
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado