Design and Maintain Databases Visually

Design and maintain databases visually

Design conceptual/logical/physical database with ER Diagram (ERD)
Generate or update database from ERD
Reverse engineer ERD from legacy database
Oracle, MS SQL, MySQL, PostgreSQL
and more...
Synchronization between class diagram and ERD

Visual Paradigm for UML
No risk. No obligation. Free TrialNo registration required for 10-days trial.
Extend it to 30 days with a simple registration.
Download FREE trial
Buy NOW! $299 only

Draw Entity relationship diagram (ERD)

Visualize your database structure with the help of ERD. Visual Paradigm's award winning model environment lets you draw ERD efficiently and expressively.
1. Conceptual data model
  
  Outline the primary entities/components of proposed system by drawing a high level design.
2. Logical data model
  
  Refine conceptual design to include/exclude primary entities and relate them.
3. Physical data model
  
  The most detailed design that is readily adaptable to physical database.
4. Categorizing entities with stereotypes
  
  Make use of stereotypes to distinguish different kinds of entities. Furthermore, apply different colors to stereotypes to make your design more presentable.
Generate and reverse database

In addition to visualizing database with ERD, you can also construct database with resulting ERD. All you need is to specify the connection information of target database, and that's it!
1. Generate database
  
  Design database with ERD in quick, and build a complete database in seconds!
2. Reverse engineer ERD from database
  
  Visualize database schema in ERD. This helps you understand the structure of current database and to carry out enhancement easily!
3. Update database
  
  Review and refine a database schema with ERD, and execute the changes back to database. You do not need to run any SQL statement or to worry about the completeness of data!
Generate Hibernate mapping and Java code

Develop applications that store and retrieve data to and from database. With Visual Paradigm's ORM (object/relational mapping) support, you no longer need to deal with any SQL statement. Time is saved, quality of application is assured!
1. Generate Hibernate mapping
  
  Store and retrieve domain objects via Object/Relational Mapping (ORM).
2. Generate code for accessing database
  
  No more error prone SQL programming! Develop application with modern object oriented approach - Store and retrieve data will objects.