I think you're making the common mistake of confusing relational databases with entity-relationship modeling. I can't really figure out your foo example though

I think you're making the common mistake of confusing relational databases with entity-relationship modeling. I can't really figure out your foo example though, needs to be a bit more specific.