Assertions and Triggers in SQL - PowerPoint Presentation

478 views
Uploaded On 2016-09-09

Assertions and Triggers in SQL - PPT Presentation

Assertions How to test if and FD is satisfied ASSERTIONS CREATE ASSERTION assertionname CHECK predicate Example We require that the sum of sailors and boats is smaller than 100 Here we need to specify a constraint between two tables ID: 463480

create trigger sid salary trigger create salary sid statement insert action condition select professor row customer assertion check event account sailors referencing

Link:

Copy

Embed:

<iframe width="560" height="315" src="https://www.docslides.com/embed/463480" frameborder="0" allowfullscreen></iframe>

Download Presentation from below link

Download Presentation The PPT/PDF document "Assertions and Triggers in SQL" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.