We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

MS Visio Entity Relationship Diagram (ERD) doesn't allow multiple foreign keys from the same entity pointed by the same primary key

romaciel
romaciel asked
on
Medium Priority
4,266 Views
Last Modified: 2008-01-09
I have a 'material' table and a 'composition'  table.
'composition' has 2 foreign keys: 'Input' and 'Product'.
'material' primary key is 'Id'.
I created two 1 to many relationships: Id --> Input and Id --> Product.

Although this works well in "real life" (in the database schema), I was not able to represent it in Visio 2003 using the ERD database modeling tool. If I try to associate Id to Product after having associated Id to Input, Visio simply changes the previous association to the new one. I can never have both at once. (I am not using reverse engineering at this point)

How can I document this ERD with Visio?

thanks,

Ricardo
Comment
Watch Question

You're pointing the arrows in the wrong direction, aren't you? Try dragging them in the opposite direction.

Author

Commented:
Thanks, I indeed misrepresented the association.  
The symbol could be something like Id --< Input and Id --< Product, with < standing for crow's feet.

The relationship I unsuccefully  tried to build in Visio was material PK (Id)  one to many composition FK(Input)  AND
material PK(Id) one to many composition FK(Product).

The relationships above describe materials that can simultaneously be products or inputs (raw materials). 'composition' is the association table that associates one material as a product with (one of) its input(s).

I can have either, not both relationships, in Visio database modeling.
You can have the two foreign keys you mention, but Visio may insist on you specifying different verbs describing the associations (defaults are "has" and "is a" I think off the top of my head). I don't have Visio installed on the PC I'm at right now, but can you describe how you are creating these relationships? Are you dragging two new relationship connectors onto the diagram and then connecting them?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.