Re: DBDesign Q

Yes. I don't usually use the various tools for design, only for reverse engineering. Some here are confusing entities with tables, and relationships with foreign keys. The original question was phrased as entities and relationships, which exist in an ERD. Tables and foreign keys may be deduced from an ERD and exist in a relational schema. My answer referred to these distinctions.

"Joe "Nuke Me Xemu" Foster" <joe_at_bftsi0.UUCP> wrote in message news:1069715721.975729_at_news-1.nethere.net...
> "Alan" <alan_at_erols.com> wrote in message
<ews:bpttkf$1rvv8s$1_at_ID-114862.news.uni-berlin.de>..
>
> > Very briefly. An ERD models business entities and relationships, and
there
> > can be > 1 relationship between the same enities. When you map the ERD
to a
> > realtional schema these multiple relationships combine into
non-redundant
> > tables.
>
> Are you sure you're not misinterpreting an ERD tool's quirks as Gospel?
>
> --
> Joe Foster <mailto:jlfoster%40znet.com> KrazyKookKultz!
<http://www.xenu.net/>
> WARNING: I cannot be held responsible for the above They're
coming to
> because my cats have apparently learned to type. take me away,
ha ha!
>
>
Received on Tue Nov 25 2003 - 21:42:48 CET