Sumários
Advanced concepts in DBMS
17 Dezembro 2024, 16:00 • Ana Paula Pereira Afonso
Concepts in DBMS: Overview of transaction management. Security and authorization. Database application development. No relational databases and big databases.
Laboratory class: SQL/DML
10 Dezembro 2024, 18:00 • Ana Paula Pereira Afonso
Laboratory class: SQL/DML
Complex Integrity Constraints in SQL Schema
10 Dezembro 2024, 16:00 • Ana Paula Pereira Afonso
Complex integrity constraints in SQL. Constraints over a single table.
Domain constraints and distinct types. Assertions: ICs over several tables. Triggers and active databases.
Examples of triggers in SQL. Designing active databases. Why triggers can be hard to understand. Constraints versus triggers. Other uses of triggers