IPT Logotipo do IPT

Undergraduate in 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

Lecturer
- António Casimiro Teixeira Batista

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 data base applications and commands with MSAccess.

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
(2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley
(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
Microsoft Access 2016

 

 

 


<< back to Curriculum Plan
Elemento gráfico

News | Agenda

NP4552
Financiamento
b-on
santander
erasmus
catedra
Financiamentos