Re: Peter Chen and Charles Bachman

From: Leandro Guimarães Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm>
Date: Wed, 05 May 2004 17:16:08 -0300
Message-ID: <pan.2004.05.05.20.16.08.806243@dutra.fastmail.fm>

Em Wed, 05 May 2004 15:06:11 -0400, Laconic2 escreveu:

> an ER model is a "data model" but it is not a "database
> model".

Hair splitting.

An ERD is a diagram. A draft. For presentation. Nothing more.

> That is to say, all the relationships in the data that are
> inherent in the composition of the data, whether it's adjacency,
> navigational, or by common key data, are omitted from this model.

'Common key' is referential integrity, not 'relationships'.

> That means that once you have an ER model that is satisfactory to both the
> SMEs and the designers, you are still free to choose an implementation,
> without having to "undo" decisions made in the ER model. As has been
> said before in this forum, it's the difference between analysis and
> design.

So it is not a logical model. At most a conceptual one, and incomplete at that.

-- 
Leandro GuimarÃ£es Faria Corsetti Dutra           +55 (11) 5685 2219
Av Sgto Geraldo Santana, 1100 6/71               +55 (11) 5686 9607
04.674-000  SÃ£o Paulo, SP                                    BRASIL
http://br.geocities.com./lgcdutra/

Received on Wed May 05 2004 - 15:16:08 CDT