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>
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.comReceived on Mon Oct 01 2001 - 15:24:50 CEST