I have changed the categories, so that multiple categories per picture should be possible. I hope it will work and stand the test of time.
It is the same system as with the tags and albums (pivot table), + some extra work was needed (for the previous/next photo-functions for example and for the queries, where photos can be filtered by category and year).