Long answer: That is one of the most common problems while dealing with (MySQL) BDs. You could scan all places where there might be a reference to the deleted image and fix it when you delete an image, or refuse to delete the image if there are references to it. If you're using an InnoDB table, it is possible to delete recursively -- take a look at the manuals.

Short answer: It depends on what problem you have.