Display primary : foreign key relationships in Visio database diagram
database, database-design, erd, uml, visio
Solution
As far as I know, what is in ER modeling known as "role" cannot be automatically displayed on the relationship line. However, foreign keys should be marked automatically in the child table, provided the parent and child fields are properly connected in the relationship's definition:
Problem
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!?