Robust and Easy to Use Data Modeling Tool
DeZign for Databases is an intuitive data modeling tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular databases (Oracle, MS SQL, MySQL, PostgreSQL,...).
DeZign for Databases offers a sophisticated visual data modeling environment for database development that makes your database development process much easier. The tool reduces faults in database development and improves your productivity. You can visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize.
Visual Database Modeling
Entity Relationship Diagramming. DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases. In your diagram you can visually make a design using entities, relationships, subcategories, group boxes and text blocks. Entity symbols are used to define database table structures, including details about columns (attributes), primary keys, null, unique, foreign keys, domains, check constraints, .... Relationships are drawn between entities and can include a name, abbreviation, description and the cardinalities (zero, one, many, ...). The diagram editor user interface fully supports drag-and-drop of entities, relationships, subcategories, group boxes and text blocks.
Industry standard design notations. You can draw your entity relationship diagram (ERD) based on data modeling notations defined by IDEF1X or Crow's Foot (Information Engineering).
Multiple display modes. The software will display model information at various levels. These display modes can be used at various stages of model development or can be used to convey model information in abstract or in varying depths of detail.
Pan and zoom window. Quickly navigate around large diagrams with the Pan and Zoom window. This window gives you a "birds-eye" view of your diagrams.
ER-Modeling. DeZign for Databases supports the ER-modeling techniques. Some advanced features like N:M-relationships (many-to-many relationships) and sub categories (inheritance) are also supported. "DeZign for Databases" will take care of the translation of the ER-Diagram (your data model) to the physical database.
Our data modeling product offers bi-directional compare and synchronize functionality for all synchronization use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model.
When any change is made to either the model or database, DeZign for Databases provides a comprehensive comparison of all differences. Changes can be moved from model-to-database (generates intelligent modification scripts) or database-to-model. With the comparison options you can control what will be seen as a difference.
Doug Newton, Sr. Mgr, Business Applications/Data Architecture