Updating Data


Respond to the following in a minimum of 175 words: 

One of your duties as a data specialist at a local bank includes updating customer data. You were given training and a job aid to complete the task, but you accidentally updated the wrong records.

Your supervisor discovered this mistake when she walked by your desk seconds after you ran your SQL UPDATE statement against the database and noticed the message “113,253 records updated,” and she knew your task was to update only 10 records. Your update criteria must have been incorrect.

Discuss the most important difference between updating and selecting data in terms of data integrity.

  • How can you know that you updated data correctly?
  • How can you prevent making a mistake when you update data?
  • How do you discover a mistake after you have made one?
  • If you discover you made a mistake, what are some ways to correct it?