I'm not sure that relational databases are "unable" to model something like this, since I recall from years ago Date describing how to do something like this. D

I'm not sure that relational databases are "unable" to model something like this, since I recall from years ago Date describing how to do something like this. Don't remember the details, but you might want to look into Date's writings.