Solved

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

Posted on 2009-04-11
3
310 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:ditallop
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24123362
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
 

Author Comment

by:ditallop
ID: 24123415
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
 

Author Closing Comment

by:ditallop
ID: 31569221
thanks so much for answering...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question