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.