Posts

How-to and Why Control the Visibility of Connectors in ERD when Reverse Database

00-erd-conn-thumbThe reverse database tool of VP-UML provides a handy approach to instantly convert a relational database into an ERD, to aid in the studying of database structure, entities properties and their inter-relationships.

Being able to study a database with an ERD is great because ERD is so easy to read and understand. However, the relationships among entities may increase the complexity of diagram when there are many entities and are highly coupled. If you just want to focus on seeing the database tables and their columns, but not pretty much interested in their inter-relationship, you can optionally form an ERD database diagram with solely entities, without including their relationships. In this article, you will see how to form an ERD from a MS SQL database, with just entities showing in the diagram. You will also learn how to optionally show the relationships.

Read more