数据库系统原理(英文)-8-09.ppt

PART2;Chapter8

ApplicationDesignandDevelopment;

Casestudyusedinthischapter;§8.6Trigger(触发器);8.6Trigger(cont.);Supposethat,insteadofallowingnegativeaccountbalances,thebankdealswithoverdrafts(透支)byfollowingactions

settingtheaccountbalancetozero

creatingaloanintheamountoftheoverdraft

givingthisloanaloannumberidenticaltotheaccountnumberoftheoverdrawnaccount

Triggeroverdraft-trigger

thetriggeringeventisupdateonbalance

theconditionforexecutingthetriggerisanmodif