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?
Paula DiTalloIntegration developerAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
So stakeholderID, contactID forms the primary key of that table and in your ER diagram show both of them as primary keys.
What do you mean by Alternate Key
0
 
Paula DiTalloIntegration developerAuthor Commented:
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.
 
0
 
Paula DiTalloIntegration developerAuthor Commented:
thanks so much for answering...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.