数据库系统原理(英文)-8-11.pptVIP

April 2011 Database System Concepts - Chapter8 Application Design and Development - PART 2 RELATIONAL DATABASES Chapter 8  Application Design and Development Suppose that, instead of allowing negative account balances, the bank deals with overdrafts (透支) by following actions setting the account balance to zero creating a loan in the amount of the overdraft giving this loan a loan number identical to the account number of the overdrawn account Trigger overdraft-trigger in Fig.8.8 the triggering event is update on balance the condition for executing the trigger is an modification to the ac