Sumários

Conceptual design with ER model IV and Relational Model I

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

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

Conceptual design for large enterprises. Integrity constraints. Conceptual design validation.

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

11 Outubro 2022, 13:30 • Ana Paula Pereira Afonso

Conceptual design with ER model - exercise Sopontes management and Tour management

Conceptual design with ER model

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

Conceptual design with ER model - exercise Intership (cont.)

Conceptual design with ER model II e III

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

E/A modeling: Weak entities, aggregation and generalization.

Conceptual design with the ER model. Entity versus attribute. Entity versus relationship. Ternary vs aggregation.

Conceptual design with ER model

4 Outubro 2022, 13:30 • Ana Paula Pereira Afonso

Conceptual design with ER model - exercise Intership (cont.)