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