I am coming back to DB design after almost 20 years away and have a challenging conundrum.
For our Temple, we have a long contact list. Some contacts are alive, others have passed on.
We have a Columbarium where people buy niches when alive and designate whose ashes are to be kept there. Often...