Publication in the Diário da República: Despacho nº 10766/2011 - 30/08/2011
3 ECTS; 1º Ano, 1º Semestre, 42,0 TP + 4,0 OT , Cód. 911238.
Lecturer
- António Casimiro Teixeira Batista (2)
- Ana Carla Vicente Vieira (2)
(1) Docente Responsável
(2) Docente que lecciona
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 complex SQL (Structured Query Language) commands.
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. First normal form
(1FN), second normal form (2FN), third normal form (3FN) and
Boyce-Codd normal form.
4 - Entity-relationship method. Extended E-R.
5 - SQL. SQLs DDL commands. SQLs DML commands
Evaluation Methodology
Theoretical test.
Laboratory works/exercises.
Bibliography
- Date, C. (2003). An Introduction to Database Systems. (Vol. 1). US: Addison Wesley
- Pereira, J. (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
