Another modelling question for you all.
I have come across a number of models where links have been modelled but do not have any associated satellite tables. The link effectively represents some kind of relationship. The way I see it is that if the link has no contextual attributes (satellite) then it serves no real purpose. A relationship without context is at best ambiguous at worst utterly misleading. We can't really infer anything about the relationship.
I have seen a completely opposite approach which says that link should never have satellite tables and if the modelling exercise creates one then the link table should be converted into a hub.
So rather than this:
The model should look like this.
I don't understand that reasoning at all. Can anybody explain this approach?