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