Tag Archives: ERD

Organize Data Models Under Use Cases

Posted by on February 17, 2012 No comments

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

Posted by on December 6, 2011 No comments
Different environments have their own database settings

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

Posted by on September 20, 2011 No comments
Version of SQL Server: 2008

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 What Version of MySQL You Are Using

Posted by on September 20, 2011 No comments
Version information that shows in welcome message

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 DB-VA/VP-UML/SDE. Read more »

Progressively Develop Conceptual, Logical and Physical ERDs

Posted by on July 29, 2011 No comments

Entity-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 products (e.g. VP-UML), you can systematically and easily progress through these stages of development in data modeling.

Read more »

Reverse database without overwritten entities

Posted by on September 16, 2010 No comments

When you reverse database, you will find all existing entities are overwritten in the project. This page is going to teach you how to solve this problem.

Read more »

Reusing ERD entity in business process diagram

Posted by on July 8, 2010 No comments

With BP-VA, you are allowed to re-use ERD entity in business process diagram. In this page, you will learn how to re-use entity in business process diagram by dragging and dropping.

Read more »

Pin specification dialog box in ERD

Posted by on July 7, 2010 No comments

By pinning, users can read those specification dialog box of various model elements consecutively, no longer have to close the previous specification dialog box and open new specification dialog box repeatedly. Reading the specification dialog box of different entities in ERD now becomes an easy task.

Read more »

Database design with schema

Posted by on July 5, 2010 No comments

Since DB-VA supports schema, users can make use of model to manage database. Users can develop ERDs under models, thereby, entities in different models can share the same name, but different schema. This page will demonstrate how to create model, how to create ERD under model and then how to apply schema.

Read more »

Copy models across projects

Posted by on June 21, 2010 No comments

Users can copy and paste models not only between diagrams, but also across projects in VP-UML. This page is going to show you how to copy and paste model across projects within the same application.

Read more »