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
Teaching Method
Practical and laboratory classes with solving practical cases.
Software used in class
Microsoft Access;
Microsoft SQL Server.
