Adding relationships in an ERD diagram

General Questions/Discussions
1

I am new to VP and UML so I hope this is not too dumb of a question.

I’m using an ERD diagram to design my database structure. What I would like to do is add a relationship between two existing columns from two tables. As it is now, I have to add a relationship, go into the specification and select the columns, and then delete the unwanted column that is automatically created when the relationship was added.

Is there anyway to add a relationship between two existing columns without VP adding the unwanted column automatically?

Thank you.

2

Hi Pro3carp3,

Thank you for your post. At the moment, it’s the only way to add relationship between existing columns in two entities, I’m sorry about this fact. However, we will investigate the possibility to add relationship without automatically added column. Once there is any news on this issue, I’ll come back to you immediately.

For any inquiries, please feel free to contact me.

Best regards,
Lilian Wong

3

Thank you, Lilian.

I do suggest that this would be a beneficial feature to many and recommend that it be added in an upcoming release.

4

Hi Pro3carp3,

Sorry for my late reply. Our engineers have decided to support this in the future already. Also, I’ve leave a private message to you about the details of this issue, please have a check in your private message. Thanks!

Best regards,
Lilian Wong

5

Hi Pro3carp3,

Sorry for the delay. I would like to share with you that our current version VP Suite 3.3 (which VP-UML 6.3 is included) supports adding relationship between 2 columns without additional column created.

Below is the link of the flash movie showing this enhancement in ERD:
http://files3.visual-paradigm.com/200806/FlashDemo/erd_add_relationship.htm

You can download the installer and new evaluation key for VP Suite 3.3 from our Download site in our website (http://www.visual-paradigm.com/download/). More details about the new features and enhancements can be found at http://www.visual-paradigm.com/product/news.jsp
I hope you will enjoy our new version product!

If there is any inquiries, please feel free to contact me again.

Best regards,
Lilian Wong

6

Lillian,

I installed the new version and it works great! Now I can use VP as I intended when I made the purchase. Thank you very much!

7

Hi Pro3carp3,

You are welcome. If there is anything I can help in the future, please feel free to contact me again.

Best regards,
Lilian Wong