Deleting Contact does not delete tags applied to Contact from civicrm_entity_tag table
I have noticed that when deleting a Contact the tags applied to that Contact are not removed from the civicrm_entity_tag table. This results in incorrect counts for how often the tags are used, and I use those counts in my application. It seems like this is an oversight for ensuring that all records for an entity_id are removed from every table when deleting that Contact.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information