[prev] [index] [next]

Exercise: Triggers (2)

Requirement: maintain assets in bank branches
  • each branch has assets based on the money held there
  • whenever an account changes, the assets of the corresponding branch should be updated to reflect this change
Some possible changes:
  • a new account is opened
  • the amount of money in an account changes
  • an account moves from one branch to another
  • an account is closed
Implement triggers to maintain Branch.assets