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_at_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 - 15:24:50 CEST

Original text of this message