Re: 1-1 relationships

From: Jan Lenders <J.Lenders_at_Betuwe.net>
Date: Tue, 12 Dec 2000 08:35:08 GMT
Message-ID: <914nvt$uvk$1_at_nnrp1.deja.com>


In article <91004h$ig2$1_at_news.tue.nl>,   hidders_at_win.tue.nl (Jan Hidders) wrote: <snip>

> > Some programmers will insist you build just one table to keep things
> > 'simple'. Later they'll find some unintended use for the bogus
> > relationships, sooner or later it's bound to happen. The single,
 simple
> > table won't seem so simple.
>
> When data modelling you shouldn't listen to programmers, you should
> listen to users. :-)

I agree; if there is a reason why two entities appear in the conceptual model in a 1-to-1 relationship the end user must have considered them as being different things.
As a data modeler it is your job to know *why* this is true.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 12 2000 - 09:35:08 CET

Original text of this message