Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: E/R modeling: relationship's attributes

Re: E/R modeling: relationship's attributes

From: Jan Hidders <hidders_at_gmail.com>
Date: 1 May 2006 06:16:12 -0700
Message-ID: <1146489372.676898.102030@g10g2000cwb.googlegroups.com>

Sticky Bit wrote:
> Hello,
> In Chen's Entity/relationship model, relationships too can have attributes.
>
> How should I represent these relationships in a database? In my view, if I
> represent these relationships' attributes as fields in a table, the
> relationship becomes a relation: an entity...

If the relationship has no attributes but is a many-to-many relationship it also might be implemented as a relation. Whether you call that "becomes an entity" or not is only a matter of definition and has no practical consequence or relevance.

Received on Mon May 01 2006 - 08:16:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US