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
