Electronics and Computer Engineering
3 ECTS; 1º Ano, 1º Semestre, 42,0 TP + 4,0 OT
Provide the students with skills to interact with Databases Management Systems (DBMS) using standard tools, to design formally correct databases and to produce complex 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%), workout sheets exercises(20%) and evaluation tests(50%).
Exam Evaluation: Written Test (50%); CAss (50%).
- Pereira, J. (1989). Tecnologia de Base de Dados. (Vol. 1). Portugal: FCA - Editora Informática
- Date, C. (2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley
- Ana, V. e Antonio, B. (0). Apontamentos de ABD. Acedido em 1 de setembro de 2015 em http://e-learninng.ipt
Method of interaction
Theoretical-practical and laboratory classes including problem solving and experimental work.
Software used in class
Microsoft Access 2016