DeZign for Databases
|
Powerful database design and modeling tool. Design, create and reverse engineer databases. DeZign for Databases is a database modeling and design tool with an intuitive visual interface thatallows you to accurately design, create and maintain your database. Visual data modeling with an intuitive Entity Relationship Diagram editor Database generation, reverse engineering and database modification (New) Compare data model versions (New) Report generation in MS Word (New), PDF (New)and HTML And much more...
DeZign for Databases is an intuitive database design tool for developers and DBA's that can help you model, create and maintain databases. DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases and automatically generates the most popular SQL and desktop databases.
Visual Database Modeling
DeZign for Databases offers a intuitive visual interface that allows you to accurately design your database. It uses entity relationship diagrams (ERDs) to graphically design databases and produces high quality database diagrams, enabling you to present your design at various levels of detail.
Database Life Cycle Support
Generate databases: Generate complete DDL scripts to create your database or generate your database directly.
Import databases: Derive a graphical data model from existing databases.
Modify databases: Changes made to the data model can be applied to a database. DeZign for Databases will generate intelligent alteration code to modify your database.
Update model from database: Connect to your database and view the differences between your database and your data model and selectively apply those differences/changes to the data model.Visual Database Modeling
DeZign for Databases offers a intuitive visual interface that allows you to accurately design your database. It uses entity relationship diagrams (ERDs) to graphically design databases and produces high quality database diagrams, enabling you to present your design at various levels of detail.
Database Life Cycle Support
Generate databases: Generate complete DDL scripts to create your database or generate your database directly.
Import databases: Derive a graphical data model from existing databases.
Modify databases: Changes made to the data model can be applied to a database. DeZign for Databases will generate intelligent alteration code to modify your database.
Update model from database: Connect to your database and view the differences between your database and your data model and selectively apply those differences/changes to the data model.
DeZign for Databases is an easy to use; repository-based data modeling tool that help you design databases for desktop and client/server applications.
Visual Data 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, ...). You can create identifying and non-identifying relationships.
The diagram editor user interface fully supports drag-and-drop of entities, relationships, subcategories, group boxes and text blocks. Moving an entity automatically results in a redrawing of your relationship lines.
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. DeZign for Databases 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. You can display an entity with all attributes, keys only or no attributes but only the entity name. You can use indicators for key attributes. Another display option is to show the data types next to the attribute name.
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 database design) to the physical database (your physical tables or your SQL schema).
DeZign for Databases supports the logical and physical data-level from a single specification achieved by using automatic foreign key migration at design-time. A modification to a property of a relationship or to a primary key will automatically affect foreign keys.
The help files contain detailed documentation on database modeling.
Database Lifecycle Support
Reverse Engineering. You can use DeZign for Databases' reverse engineering abilities to create a data model diagram of your current database system. You can import an existing database by connecting to the database directly or by importing a SQL DDL script. Your complete database will be imported including tables, foreign keys, sequences, triggers, procedures and views. While reverse engineering, the program analyzes the database to find relationships not expressly defined to the database.
Forward Engineering. DeZign for Databases can generate databases directly from your data models (ER-diagrams). For SQL databases, the SQL DDL scripts to create your database will be generated. For non SQL databases, the physical database files will be generated directly. You can control what will be generated. Generate individual parts of your model. Generate tables, foreign keys, indexes, domains, sequences, procedures, triggers and views.
Database Modifications. You can update a database from a data model. DeZign for Databases allows you to apply design changes made to your data model to a database. DeZign for Databases compares differences between two versions of your data model and generates intelligent alteration code.
Update Model From Database. Connect to your database and view the differences between your database and your data model and selectively apply those differences/changes to the data model.
Supported Databases
DeZign for Databases supports the following databases:
* Clipper
* dBase
* DBISAM 4
* Firebird 1.5, 2
* FoxPro
* IBM DB2 Universal DB 7, 8
* InterBase 5, 6, 7
* Informix 9
* MaxDB 7
* MS Access 95, 97, 2000, 2003, 2007
* MS SQL Server 6.5, 7, 2000, 2005
* MySQL 3, 4, 5
* NexusDB V2
* Oracle 7, 8, 9, 10, 11
* Paradox
* Pervasive v8, PSQL v9
* PostgreSQL 7, 8
* Sybase ASE 11, 12
Better Database Designs
Model Validation. You can validate a model for errors any time during the design process. During validation, DeZign for Databases checks to make sure the elements in your model are correct and complete.
Automatic Foreign Key Migration. DeZign for Databases supports the logical and physical data-level from a single specification achieved by using automatic foreign key migration at design-time. A modification to a property of a relationship or to a primary key will automatically affect foreign keys.
Reusable Objects. Domains are reusable user-defined types or "attribute templates" that promote consistent domain definitions. You construct domains as you would attributes, specifying a name, datatype properties, default values and validation rules.
The license of this software is Free Trial Software, the price is $129.00, you can free download and get a free trial.

