Relational Model I and II (1st part)

19 Outubro 2021, 16:00 • Ana Paula Pereira Afonso

Introduction to the relational model. Creating and modifying relations using SQL.Integrity constraints over relations. Key constraints. Foreign key constraints. General constraints.

Laboratory class: Access to Mysql. SQL/DDL.

19 Outubro 2021, 13:30 • Ana Paula Pereira Afonso

Laboratory class: Access to Mysql. Introduction to SQL/DDL.

Conceptual design with ER

12 Outubro 2021, 18:00 • Ana Paula Pereira Afonso

Conceptual design with ER model - exercise Tour management

Conceptual design with ER model IV

12 Outubro 2021, 16:00 • Ana Paula Pereira Afonso

Conceptual design with the ER model. Aggregation versus ternary relationships.

Conceptual design with ER

12 Outubro 2021, 13:30 • Ana Paula Pereira Afonso

Conceptual design with ER model - exercise Tour management