Display primary : foreign key relationships in Visio database diagram

database database-design uml visio erd
hurleystylee picture hurleystylee · Aug 20, 2012 · Viewed 57.4k times · Source

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the diagram. The only workaround I can find is to insert a text box on top of the relationship and manually type it in (see image). Or you can kinda do the same by naming the relationship and displaying that. However, both of these are very manual and time-consuming. Plus I've already defined the relationship, so why should I have to type it in again!?

enter image description here

Answer

Allen picture Allen · Jan 8, 2013

I realize that this post is old, but just in case you have not found an answer: http://office.microsoft.com/en-us/visio-help/define-a-relationship-in-a-database-model-diagram-HA010115484.aspx#BM4 (Section Show relationships and their properties in a diagram).

Hope this helps!

Related questions

Multiplicity vs Cardinality

When talking about data models and databases, the term Cardinality is often used to describe the number of allowed elements in a given set. UML often refers to the same property as Multiplicity. Is there any differences between these two …

Read More
How to decide whether to use ER or UML for modelling?

A UML diagram can be used both to model database designs and class designs, but an ER diagram should be used exclusively in database problems. How do you pick one graphical representation over the other?

Read More
How do I add multiplicity values in StarUML

I am studying Database Development and I am at the stage where I have to create my own ER Models. Everything is fine so far with StarUML however the course notes don't mention how to add muliplicity options between entity …

Read More