Improve Room database constraints and deletion

[jonaskon]

There are some specific use cases that can lead to invalid states in the room database, e.g downloading a dataset where not every category has a representative picture