When Deleting a content asset, it would be nice to have a message that states something like this:
"This asset has relative links to the following dependency assets: [list of dependencies]. If you delete this asset, then the references to these dependent assets will also be deleted, affecting the output of these other assets."
A secondary option without deleting the relative links would be a message warning them that there will be dead links if they delete the asset and those dead links will affect their output.
Reason: If an author deletes an asset which is being referenced via an Asset Selector, the relative link between those two is now broken. When the parent asset is then published, the result is missing content (because it was deleted). The message would at least warn them that this will happen.