Sumários
Course presentation and ER model
31 Outubro 2023, 13:30 • Ana Paula Pereira Afonso
T/P Course presentation. Conceptual design with ER model - exercise intership management
Laboratory class: Access to Mysql. SQL/DDL.
17 Outubro 2023, 18:00 • Ana Paula Pereira Afonso
Conceptual design with ER model - exercise Tour management
Laboratory class: Access to Mysql. Introduction to SQL/DDL.
Relational Model I and II (1st part)
17 Outubro 2023, 16:00 • Ana Paula Pereira Afonso
Relational Model I: Introduction to the relational model.
Creating and modifying relations using SQL.Integrity constraints over relations.
Key constraints. Foreign key constraints. General constraints.
Relational Model II (1st part): Integrity constraints over relations.
Key constraints. Foreign key constraints. General constraints.