Electronics and Computer Engineering, Publication in the Diário da República - Despacho n.º 7795/2021 - 09/08/2021
3 ECTS; 1º Ano, 2º Semestre, 42,0 TP
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.
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.
Continuous Assessment (CAss):
Practical assessment(30%), worksheets (20%) and tests(50%).
Exam-based assessment: Written Test (60%); CAss (40%).
(1989). Tecnologia de Base de Dados. (Vol. 1). Portugal: FCA - Editora Informática
(2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley
Method of interaction
Theoretical-practical and laboratory classes including problem solving and experimental work.
Software used in class
Microsoft Access 2016