Re: Access as a RDBMS--why the multiple relationships?

From: mAsterdam <>
Date: Sat, 15 Dec 2007 10:16:12 +0100
Message-ID: <47639b34$0$85782$>

Evan Keel schreef:
> raylopez99 wrote:

>> ...TWO, not just one, relationship arrows between
>> tables.  But I think (and I just want confirmation of this) that one
>> of these two relationship arrows is bogus, and more like a query than
>> a true relationship.


> My 2 cents. In my experience, when you have more than one relationship among
> tables you are really describing roles. For example: Professor tutors
> Student and Professor advises Student, where tutor and advisor are roles.

2 cents more. You just do not run into this non-problem when you think of roles.
You are describing roles a lot of the time, period. That is, not only when you have more than one relationship.

What you see depends on where you stand.
Received on Sat Dec 15 2007 - 10:16:12 CET

Original text of this message