Sumários

Logical Database Design: ER to Relational

27 Outubro 2020, 18:00 Ana Paula Pereira Afonso

Logical Database Design: ER to Relational - exercise Intership management, Sopontes and Tour management.


Relational Model IV

27 Outubro 2020, 16:00 Ana Paula Pereira Afonso

Introduction to Views, Data Independence, Security. Updates on Views. Destroying/Altering Tables and Views.

Project-E1: A solution and common errors.


Logical Database Design: ER to Relational

27 Outubro 2020, 13:30 Ana Paula Pereira Afonso

Logical Database Design: ER to Relational - exercise Intership management.


Laboratory class: Access to Mysql. SQL/DDL e DML

20 Outubro 2020, 18:00 Ana Paula Pereira Afonso

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


Relational Model III - Logical Database Design

20 Outubro 2020, 16:00 Ana Paula Pereira Afonso

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. Translating weak entity sets, class hierarchies and Aggregation.