Sumários

Logical Database Design: ER to Relational

25 Outubro 2022, 13:30 Ana Paula Pereira Afonso

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


Laboratory class: Access to Mysql. SQL/DDL.

18 Outubro 2022, 18:00 Ana Paula Pereira Afonso

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


Relational Model II (1st part) and III

18 Outubro 2022, 16:00 Ana Paula Pereira Afonso

Relational Model II (1st part) 
Integrity constraints over relations. Key constraints. Foreign key constraints. General constraints.
Relational Model III - Logical Database Design
Logical database design: ER to relational. Entity sets to tables. 
Relationship sets (without constraints) to tables. 
Translating relationship sets with key constraints.
Translating relationship sets with participation constraints. 


Laboratory class: Access to Mysql. SQL/DDL.

18 Outubro 2022, 13:30 Ana Paula Pereira Afonso

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


Conceptual design with ER model

11 Outubro 2022, 18:00 Ana Paula Pereira Afonso

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