IPT Logotipo do IPT

Ano Letivo: 2016/17

Engenharia Electrotécnica e de Computadores

Database Applications

<< back to Curriculum Plan

Publication in the Diário da República: Despacho nº 10766/2011 - 30/08/2011

3 ECTS; 1º Ano, 1º Semestre, 42,0 TP + 4,0 OT , Cód. 911238.

Lecturer
- António Casimiro Teixeira Batista (2)
- Ana Carla Vicente Vieira (2)

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

Prerequisites
Not applicable.

Objectives
Provide the students with skills to interact with Databases Management Systems (DBMS) using standard tools, to design formally correct databases and to produce complex SQL (Structured Query Language) commands.

Program
1- Relational Model
2 - Relationships. Instances and schemes. Data dictionary . Keys.
Primary key, foreign key and indices. Integrity and rules.
3 - Functional dependencies and normalization. First normal form
(1FN), second normal form (2FN), third normal form (3FN) and
Boyce-Codd normal form.
4 - Entity-relationship method. Extended E-R.
5 - SQL. SQL’s DDL commands. SQL’s DML commands

Evaluation Methodology
Theoretical test (50%).
Practical assessment (50%): exercise (35%) and evaluation (65%) tests.

Bibliography
- Antonio, B. e Ana, V. (0). Apontamentos de ABD. Acedido em 1 de setembro de 2015 em http://e-learninng.ipt
- Date, C. (2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley
- Pereira, J. (1989). Tecnologia de Base de Dados. (Vol. 1). Portugal: FCA - Editora Informática

Teaching Method
Theoretical-practical and laboratory classes including problem solving and experimental work.

Software used in class

 

 

 


<< back to Curriculum Plan
Elemento gráfico

News | Agenda

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