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 relationshp

Re: Entity relationshp

From: David Cressey <david_at_dcressey.com>
Date: Mon, 01 Oct 2001 13:24:50 GMT
Message-ID: <C8_t7.117$h4.5200@petpeeve.ziplink.net>


Deepak,

If you are using the "Entity-Relationship" model purely for purposes of conceptual data modeling,
just record the many-to-many relationship in your model. A conceptual model isn't about implementation.

If however, you are creating a logical data model, in the form of a relational schema, then you need a table in the middle, as others have told you. The table in the middle consists of two columns, both foreign keys. One foreign key references the PK for slots, and the other foreign key references the PK for cardtypes.

You do need to read Date, or some other good book on DB design.

hth.

--
Regards,
    David Cressey
    www.dcressey.com
Received on Mon Oct 01 2001 - 08:24:50 CDT

Original text of this message

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