Lab class: Logical Database Design: ER to Relational

8 Novembro 2022, 18:00 • Ana Paula Pereira Afonso

Logical Database Design: ER to Relational - exercise Sopontes and Tour management

Relational Model IV

8 Novembro 2022, 16:00 • Ana Paula Pereira Afonso

Introduction to Views, Data Independence, Security. Updates on Views. Destroying/Altering Tables and Views.
Enforcing Integrity Constraints.
Project-E1: A solution and common errors.

Lab class: Logical Database Design: ER to Relational

8 Novembro 2022, 13:30 • Ana Paula Pereira Afonso

Logical Database Design: ER to Relational - exercise Sopontes and Tour management

Logical Database Design: ER to Relational

25 Outubro 2022, 18:00 • Ana Paula Pereira Afonso

Logical Database Design: ER to Relational - exercise Intership management, sopontes managent and tour management.

Relational Model III - Logical Database Design (cont) and Relational Model II (2sd part)

25 Outubro 2022, 16:00 • Ana Paula Pereira Afonso

Logical database design: ER to relational. 
Translating relationship sets with participation constraints. Translating weak entity sets, class hierarchies and Aggregation.

Relational Model II (2sd part). Enforcing Integrity Constraints.