Visual Paradigm logo

Database Design with ERD Tools

Design database visually with powerful Entity Relationship Diagram (ERD) tools.

Entity Relationship Diagram

Entity Relationship Diagram (ERD), a database design tool that provides graphical representation of database tables, their columns and inter-relationships. ERD is the most popular database design tool. A well-developed ERD can provide sufficient information for database administrator to follow when developing and maintaining database.

Entity relationship diagram

Table Record Editor

Enter sample records for entities in ERD. The sample records help readers understand the format of data that will be inserted. Besides, the records will be output in data specification. You can also insert them into database upon database generation.

Table Record Editor

Database View Editor*

A database view is the result of a query on the data stored in a database. You can select columns, specify where and join statements to a view and present the data as if the data were coming from one single table. In Visual Paradigm, you can edit database view in a visual editor.

Database View Editor
Ad-Hoc SQL Statements Generator

Ad-Hoc SQL Statements Generator

Run checks on Data Definition Language (DDL) or Data Manipulation Language (DML) statements for entities ad-hoc. You can select entities to generate SQL, or to generate SQL for the entire ERD.

Construct Conceptual, Logical and Physical ER Model

Conceptual, logical and physical ERD model the three different phases of a database design. While the conceptual and logical database design model database tables and their properties in a high level view, the physical ERD models the actual database schema, which involves the detailed entities' structure and their inter-relationship.

Automatic foreign key generation

Specify the resource required to execute a business process, and the resource required by each task and sub process.

Stored procedure support

Design, reverse and generate stored procedures with stored procedure shapes in ERD.

Trigger support

Design, reverse and generate database trigger.

Resource allocation

Specify the resource required to execute a business process, and the resource required by each task and sub process.

Configurable time scale

Simulate business process in real time, minute scale, hour scale or day scale to see the whole execution timeline.

* Database View editor is available in Visual Paradigm Standard, Professional and Enterprise only

Turn every software project into a successful one.