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