Archive Database Step 9: Change Safely

Practice the safe-change routine on the teaching database. For three separate changes, write the SELECT first, record how many rows it returns, then convert it into the UPDATE or DELETE and confirm the same number of rows was affected. Then do one multi-statement change inside a transaction and deliberately roll it back, confirming the data is unchanged. Write down the routine as a checklist you will actually follow when it is a real database.