Re: One-To-One Relationships
Date: Fri, 30 Nov 2007 20:04:09 GMT
Message-ID: <Z0_3j.50$6k1.33_at_trndny02>
"Marshall" <marshall.spight_at_gmail.com> wrote in message
news:b845d1a9-d7c9-4cb6-85f8-c4438bf74723_at_i29g2000prf.googlegroups.com...
In particular, their understanding of how foreign keys work is hazy and
incomplete.
If you have a many-to-many relationship, like students enrolled in courses,
it's easy to state the relationship in words. It's also easy to express in
an ER diagram: you just put crow's feet at both ends of the line.
It gets worse when there are "camps" among the stakeholders about whether
the relationship is many-to-one or many-to-many. An example is matrix
management versus conventional management.
> just fine" as a law.
>
I remember that, and I don't agree. While people understand individual
tables just fine, they don't understand schemas made up of tables
completely enough.
> do it fairly well, directly. So I see no point in any further
> methodology.
>
Based on my experience, I disagree. Received on Fri Nov 30 2007 - 21:04:09 CET