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 - 14:42:48 CST
