Re: c.d.theory glossary - RELATION

• Post for FREE via your newsreader at post.usenet.com ****

"mAsterdam" <mAsterdam_at_vrijdag.org> wrote in message news:4091691c$0$564$e4fe514c_at_news.xs4all.nl...
> Laconic2 wrote:
> [language mapping]
>
> An _entity_ in ER modelling usally gets mapped to a _table_
> in a SQL db - that would be^H^Hrepresent a _relation_ in
> relational, no? A _relation_(ship) mostly maps to a foreing
> key in the child table referring the parent. The use of
> 'association' instead of 'relation' in ER (or would it be EA,
> ERA being Entity-Relationship-Attribute, hmmm... not good)
> never really cought on.

I found this on a web page about ER modelling: "The question of what constitutes an entity and what constitutes an attribute depends mainly on the structure of the real world situation being modeled, and the semantics associated with the attribute in question"

"An entity is REPRESENTED BY (NOT is ) a set of attributes"

May I suggest that entities get mapped to a field or to a set of fields and a relation(ship) to a table ?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=