Transactions

• Transaction handling important DB task
• Transaction - set of operations that should all succeed, or fail entirely
• Use SQL COMMIT and ROLLBACK commands
• COMMIT makes a set of updates permanent
• ROLLBACK undoes all changes from last COMMIT
• Make creation of unique values (e.g., invoice #) part of the transaction