Assertion : example

Create assertion sum_constraint check

(not exists (select * from branch

where (select sum(amount) from loan where loan.bname = branch.bname)

>= (select sum(amount) from account where loan.bname =branch.bname)))

Previous slide

Next slide

Back to first slide

View graphic version