Entity relationship diagram

Entity relationship diagram

Entity Relationship Diagram (ERD) is a database design tool that provides graphical representation of database tables, the columns in tables and the relationships between tables. With neat organization of tables, table columns and flexible representation of cardinals, ERD is extremely helpful in modeling databases that have a large amount of tables and with complex relationships in between. A well-developed ERD can provide sufficient information for database administrator to follow when developing and maintaining database.

• Conceptual
• Logical
• Physical

Construct conceptual, logical and physical ER model  

Conceptual, logical and physical data models provide three distinct levels of abstraction in data modeling and database design. While the conceptual and logical model enable the high level representation of database tables and their properties, the physical model enables the modeling of actual physical database schema.

·  Database domain

Develop 'templates' for entities and entity columns in your ERD by developing database domains. Each entity domain stores a user-defined set of entity specification with specific column assignment. Save your time from drawing entities with same or similar specification.

• · 

Automatic foreign key generation

When you create an entity from an existing one, a FK will be generated if there is a PK in source.

• Smart column type assignment

When you create an entity column that has its name matched with another column, column type will be automatically assigned to ensure the consistency of database design.

• Database View editor

Visual editor for manipulating database view — the result of a query on the data stored in a database.

• Split table into two

Particularly useful when you want to create a one-to-one _INFO table (e.g. ACCOUNT_INFO) from an existing entity (e.g. ACCOUNT).

• Add sample records to tables in ERD

Input initial database record when designing database with entity relationship diagram (ERD).

• Stored procedure support

Design, reverse and generate stored procedures.

• Trigger support

Design, reverse and generate database trigger.

• Import Er Win Data Modeler project

Carry on database design by importing ERD from Er Win data Modeler project.

• Import Power Designer

Import Sybase Power Designer project file to Visual Paradigm. All model elements and diagrams layout will be kept.

make love

Author & Editor

Has laoreet percipitur ad. Vide interesset in mei, no his legimus verterem. Et nostrum imperdiet appellantur usu, mnesarchum referrentur id vim.