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: Entity and Relationship - the same thing ?

Re: Entity and Relationship - the same thing ?

From: Jan.Hidders <hidders_at_uia.ua.ac.be>
Date: Sun, 5 May 2002 16:40:02 +0200
Message-ID: <Pine.GSO.4.40.0205051623150.8319-100000@hcoss.uia.ac.be>

On Sat, 4 May 2002, Sleeves wrote:
>
> [...] For instance, having explained entities and it's attributes
> (example entity "customer" with its attributes being "name" "age"
> etc), we now go onto relations and its attributes, where the relation
> has its primary/foreign keys defined using the attributes etc, but am
> I right in saying they are exactly the same thing or am I getting
> myself totally confused here ?

The basic idea is that entities represent things that you want to say something about, and that relationships represent facts you want to say about them. This is not really a clear-cut distinction because sometimes facts are also things that you want to say something about, so some relations can also be seen as entities. Whether this is actually allowed in the modelling technique that your course is using, may depend upon the specific technique (some allow it, some don't). So your confusion is justified. :-)

Received on Sun May 05 2002 - 09:40:02 CDT

Original text of this message

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