Link to home
Start Free TrialLog in
Avatar of Paula DiTallo
Paula DiTalloFlag for United States of America

asked on

assigning unique primary keys which are two foreign keys in an association table

I have an association table with two foreign keys (e.g. stakeholderID, contactID)  that I would like to express in an er diagram.  The tools I have for drawing the er diagram are ms visio 2007 -- and sql server's diagramming feature through management studio.

also, is there any way to express an alternate key?
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Paula DiTallo
Paula DiTallo
Flag of United States of America image

ASKER

cool. ultimately i did just that--with the 2 foreign keys in the _assoc table.  alternate keys may be more of an ERwin/Oracle partnership. In general an alternate key (read: AK1, AK2, etc.) is a candidate that could be used to retrieve (generally) unique data but isn't the primary key.  I hate to use the ol' warn employee table as an example ... but its helpful in the case -- so, an emplID or socSecNum might be primary keys, but something like a badgeNum would be an alternate key.
 
Avatar of Paula DiTallo
Paula DiTallo
Flag of United States of America image

ASKER

thanks so much for answering...