Data Modeling Question

[cristian_av]

Hi

I have a model with three tables linked, but without syntetic keys. I don't know the name of this "kind" of link, cause i know it is not a syntetic or link table... Also, I wonder if this causes performance issues or not.

1) What is the name of this kind of link

2) Does this causes any performance issues?

3) Should I avoid it if possible or how should I model this?

Thanks!

[Vegar · Accepted solution]

1) I've never heard a special name for it.
2) you will not have any performance issues with it.
3) No need to avoid it. This design is better than a design where you duplicated this field to just to get single connections.

Good work!