From: Charles Wilt
What happens if the program is ended via user action, system
crash, power failure, ect... between the write to one table and
the update of the other?
You've got two choices
1) Use commitment control
2) Add lots of extra code into your application for recovery.
In this day and age, why would you write develop and application
without commitment control?