IPT Logotipo do IPT

Engenharia Electrotécnica e de Computadores

Database Applications

<< back to Curriculum Plan

Publication in the Diário da República: Despacho n.º 7795/2021 - 09/08/2021

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

Lecturer
- António Casimiro Teixeira Batista (1)(2)

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

Prerequisites
Not applicable.

Objectives
At the end of the course, students should be able to:
(1)- describe the relational model;
(2)- design databases by the E-R method;
(3)- execute SQL commands to define the data structure;
(4)- execute SQL commands to interrogate and manipulate data from a database;

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.
4 - Entity-relationship method. Extended E-R. Cardinality and participation constraints.
5 - Applications in MSAccess. Tables, Selection and Forms.

Evaluation Methodology
Continuous Assessment (CAss):
Practical assessment(30%), worksheets (20%) and tests(50%).
Exam-based assessment: Written Test (60%); CAss (40%).

Bibliography
(1989). Tecnologia de Base de Dados. (Vol. 1). Portugal: FCA - Editora Informática
(1989). Tecnologia de Base de Dados. (Vol. 1). Portugal: FCA - Editora Informática
(2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley
(2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley

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

Software used in class
Microsoft Access 2016

 

 

 


<< back to Curriculum Plan
Elemento gráfico

News | Agenda

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