Project support

13 Dezembro 2022, 18:00 • Ana Paula Pereira Afonso

Laboratory class: support to the project

Concepts in DBMS

13 Dezembro 2022, 16:00 • Ana Paula Pereira Afonso

Overview of transaction management. Security and authorization. Database application development. No relational databases and big databases. 

Project support

13 Dezembro 2022, 13:30 • Ana Paula Pereira Afonso

Laboratory class: support to the project

SQL: QUERIES

6 Dezembro 2022, 18:00 • Ana Paula Pereira Afonso

Laboratory class: exercises SQL/Data Manipulation Language (DML)

SQL: QUERIES - IV and Complex Integrity Constraints in SQLSchema

6 Dezembro 2022, 16:00 • Ana Paula Pereira Afonso

Null values. Comparisons using null values. Logical connectives AND, OR, and NOT. Impact on SQL constructs. Outer joins.

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