Sumários

Conceptual design with ER model

8 Outubro 2019, 18:00 Ana Paula Pereira Afonso

Conceptual design with ER model - Exercise Sopontes and Tour management.


Relational Model I and II (1st part)

8 Outubro 2019, 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.


Conceptual design with ER model

8 Outubro 2019, 13:30 Ana Paula Pereira Afonso

Conceptual design with ER model - Exercise Sopontes and Tour management


Conceptual design with ER model

1 Outubro 2019, 18:00 Ana Paula Pereira Afonso

Conceptual design with ER model - exercise Sopontes and Tour management


Conceptual design with ER model - III and IV

1 Outubro 2019, 16:00 Ana Paula Pereira Afonso

Conceptual design with the ER model. Entity versus attribute. Entity versus relationship.

Binary versus ternary relationships. Aggregation versus ternary relationships.
Conceptual design for large enterprises. Integrity constraints. Conceptual design validation.