Course presentation and ER model

7 Novembro 2023, 18:00 • Ana Paula Pereira Afonso

---

T/P Course presentation.
Conceptual design with ER model - exercise intership management

Relational Model II (2sd part) and Project Solution

7 Novembro 2023, 16:00 • Ana Paula Pereira Afonso

---

Relational Model II (2sd part). Enforcing Integrity Constraints.

Presentation of the solution of the project, first part. Solution and common errors.

Logical Database Design: ER to Relational

7 Novembro 2023, 13:30 • Ana Paula Pereira Afonso

---

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

Course presentation and ER model

31 Outubro 2023, 18:00 • Ana Paula Pereira Afonso

---

T/P Course presentation.
Conceptual design with ER model - exercise intership management

Relational Model III - Logical Database Design

31 Outubro 2023, 16:00 • Ana Paula Pereira Afonso

---

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. 

Translating weak entity sets, class hierarchies and aggregation.