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

From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Sat, 15 Dec 2007 10:16:12 +0100
Message-ID: <47639b34$0$85782$e4fe514c@news.xs4all.nl>

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.

[snip]

> 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.

http://orm.net

--
What you see depends on where you stand.

Received on Sat Dec 15 2007 - 03:16:12 CST