Sumários

SQL: QUERIES

7 Dezembro 2021, 13:30 Ana Paula Pereira Afonso

Laboratory class: SQL/DML


SQL: QUERIES

30 Novembro 2021, 18:00 Ana Paula Pereira Afonso

Laboratory class: SQL/DML


Relational Model II (2sd part) and Complex Integrity Constraints in SQLSchema

30 Novembro 2021, 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


SQL: QUERIES

30 Novembro 2021, 13:30 Ana Paula Pereira Afonso

Laboratory class: SQL/DML


SQL: QUERIES

23 Novembro 2021, 18:00 Ana Paula Pereira Afonso

Laboratory class: SQL/DML