Clear all

Should Links be built if they have no Satellites?

Posts: 157
Topic starter
Estimable Member
Joined: 2 years ago

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?

Topic Tags
32 Replies