Visual Paradigm Database Designer Guides
Learn how to draw entity, how to add column and how to create relationship between entities.
Conceptual, logical and physical model are three different ways of modeling data in a domain. In this page you will learn what they are and how to transit from one model to another.
An entity domain is a named set of property values that can be re-used by an entity. In this article you will learn how to define and use entity domain.
A column domain is a named set of property values that can be re-used by a column. In this article you will learn how to define and use column domain.
A default schema can be used to easily move entities on an ERD to a common schema. You will know how it works by reading this page.
Auto Column provides you with a quick way in creating entities in ERD. This page describes how to configure auto column and how to use it in creating entities in an ERD.
Enter sample table records in ERD, and have the records exported to your database in database generation. This article shows you how it works.
A database view is the result of a query on the data stored in a database. This page describes how to create a database view.
In Visual Paradigm, stored procedure is modeled in form of a procedure container. This article shows you how to create stored procedure.
In Visual Paradigm, trigger is modeled in form of a trigger container. This article shows you how to create trigger.
Unique constraints help to enforce the uniqueness of specific columns. In this page, you will see how to create unique constraints for entities in ERD.
Some databases support controlling how primary key value can be generated, through the use of an ID generator. In this article you will learn how to select an ID generator for a primary key.
Inheritance strategy is used to define the way how entities should be created and structured to respect an object model. You will learn what inheritance strategy is and how to set it in this page.
Discriminator column contains a unique value that can be used for identifying the entity in which a table record belongs to. In this article you will learn what discriminator column is.
Retrieve objects in the form of primitive array, instead of a collection when handling a data column with cardinality of many. This article shows you how Array Table works in Visual Paradigm.
Optimize the size of database, and minimizes the redundant persistent classes for handling one-to-one identifying relationship. In this page, you will learn how to work with partial table.
Visual Paradigm supports Object Relational Mapping (ORM) which maps object models to entity relational models and vice versa. This article shows you everything about mapping object model to data model.
Visual Paradigm supports Object Relational Mapping (ORM) which maps data model to object model and vice versa. This article shows you everything about mapping data model to object model.
Visual Paradigm supports mapping object model (class diagram) with data model (Entity Relationship Diagram). This article shows you how to synchronize them.
|5. Supported Database, JDBC Drivers and .NET Drivers||Table of Contents||1. Drawing Entity Relationship Diagram|