I would really appreciate some clarification, I always seem to have problems identifying relationships between tables. I always hear the term direct and indirect relationships. How do you know when a relationship should be direct or when it should be indirect. Could someone please explain in as simple way as possible please, if possible illustrate?
Hopefully this will be the last time I have this problem. May this be the overall clarification.