Knowledge Sharing Code Review

Database Change Request using PLSQL

Tom in accounting complained to your boss about a very important report that was off by several million dollars. After researching the issue you find that Tom submitted a database change request that deleted records from Tables A and B but forgot to delete from table C. He also failed to insert into Table D and did not update table E. A code review was conducted by the team lead, but because he had not done that task in about 2 years he forgot to those other steps were necessary. Also there is no referential integrity on these tables. Your boss asks you to find a way to prevent this from happening in the future. You decide to use Tribal Knowledge and set up a check list to automate the code review process.