Posts

Progressively Develop Conceptual, Logical and Physical ERDs

tomcat-thumbEntity-Relationship Diagrams (ERDs) come in 3 types in general. They describe data models on 3 levels of abstraction – conceptual, logical and physical, ranging from high-level ideas to details required for implementation. With Visual Paradigm, you can systematically and easily progress through these stages of development in data modeling.

Far from a copy & paste function only, you can actually develop a logical or physical design from a conceptual diagram, with the design tracing ability.

For example, if a new staff comes on board to work on a project’s physical design ERD, he/she can click on a database table to trace where this idea originally comes from in the conceptual diagram (to which it is inherently linked by Visual Paradigm). This function will not only bring relief to the staff but also help safeguard the project’s quality along the way.

In this article, we will show you an example on how to create a conceptual ERD and transit it to a physical ERD, from which you can generate a DLL file for database implementation. Read more

How to Group Entities in ERD Database Designer?

deletet-keyLast week, we showed you how to assign entities in an ERD to a schema. One of our users ask if there is any way to group entities in a logical manner, rather than setting the schema property reserved for physical database.

The answer is yes. You can make use of model or UML package to store and categories the entities in logical groups. The grouping can be seen in both the Model Structure and diagram. In this article, we will show you how to group entities in ERD database designer. In order to perform the steps described in this article, make sure you have Visual Paradigm installed.

Read more

How to turn off the column datatype in ERD?

In an ERD, when you represent the columns that exist in entities, you might only want to show their names but not any other property like their types since datatype is usually not required in early communication of data structure but is only required when implementing a database. In order to simplify an ERD and to avoid giving wrong information, you can hide the datatype, so that only the column names are left. For your convenience, Visual Paradigm supports hiding the datatype of columns, please follow the simple steps below. Read more

How to Assign Entities in ERD Database Designer to a Schema?

00-erd-schema-thumbVisual Paradigm for UML (VP-UML) comes with an ERD database designer where database developers can model physical database with Entity Relationship Diagram. The database designer supports popular database constructs like database table (called Entity in VP-UML), View, Sequence, Stored Procedure, Trigger, etc, supporting the need of database modeling for any kind of database management systems.

Read more

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

Organize Data Models under Use Cases

In helping you organize your modeling project, use cases can act as generic containers for all software development artifacts. Development teams can group and locate design artifacts by navigating use cases.

In this tutorial we are going to show you how to create a new data model (i.e. entity relationship diagram) and associate that with a use case. And in future, you can easily identify existing associations as such by use cases and conveniently, be taken to the related diagrams right on the spot in just a few clicks.

Read more

Personalize Database Connection Settings to Aid in Team Development

When a development team is developing a system that requires accessing a database, it is a common practice to setup local databases on each of the development environment and populate them with all the required schema of the system so that developers can develop and test the function they implement with test data in their own database, rather than working with actual data with production database.

Read more

How to Find Out What Version of SQL Server You Are Using

Visual Paradigm supports data modeling with ERD and a set of engineering features like the reverse engineering and generation of database. The features are related with each other. For example, you may generate a database from physical ERD. In order to construct a data model that helps you build a database properly, you need to name the entities and their columns properly. Besides, data types of columns should be well-considered. Just to take the type ‘char’ example, there are quite a number of similar types like varchar, varchar2, nvarchar, etc. If a wrong type is chosen for any column, you may get data corruption or result in data lost.

Read more

How to Find Out the Version of MySQL I am Using

Visual Paradigm supports data modeling with ERD and a set of engineering features like the reverse engineering and generation of database. The features are related with each other. For example, you may generate a database from physical ERD. In order to construct a data model that helps you build a database properly, you need to name the entities and their columns properly. Besides, data types of columns should be well-considered. Just to take the type ‘char’ example, there are quite a number of similar types like varchar, varchar2, nvarchar, etc. If a wrong type is chosen for any column, you may get data corruption or result in data lost.

Visual Paradigm supports all the data types you can find in any supported database management system (DBMS). You can select any data type you want for columns when drawing ERD. As the supported data types vary depending on the target version of DBMS, you need to set in the database configuration page the version of DBMS you use. With this, Visual Paradigm can list out those supported types, preventing you from selecting a non-supported type, which result in producing an inaccurate data model.

In this article, you will learn how to find out the version of your MySQL installation. Try to follow the steps get the information needed, and select the proper version range in the database configuration window of VP-UML. Read more