Complex Integrity Constraints in SQLSchema

26 Novembro 2019, 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.