A Database Development Tool by Datanamic Solutions BV

Data Sheet
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

Database Lifecycle Support
Reverse Engineering. You can use DeZign for Databases' reverse engineering capabilities to create a data model diagram of your current database system.
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.
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.

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.
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.

Model Maintenance
Diagram Management. DeZign for Databases extends your modeling power with subdiagrams. A project is a set of one or more subdiagrams that contains the specification of an entire data model.
Object Browser. The Object Browser provides an additional method for creating and modifying model objects. Rather than presenting a picture of the model in the traditional diagram window manner, the Object Browser provides an organized, ordered view of the model and its contents.
To-Do list. The To-Do list feature allows you to write a note for unfinished actions. You can attach a to-do item to all model objects (entities, relationships, attributes, sequences, triggers, procedures, views).

Version Control
Using DeZign for Databases, you can save different versions of a model for archiving, comparisons or altering a database purposes. These versions are stored in the project file.
Manage Versions. lYou can archive your current model, delete versions or edit the version label or the version comments. You can always return to an older version of your data model.
Automatically Save Versions.l DeZign for Databases can automatically create a version of your data model when you save your project to disc and when you generate a database or alter a database.
Compare Versions. lDeZign for Databases offers advanced, bidirectional comparisons between two versions. Changes made to the data model will be made visible and DeZign for Databases can generate intelligent alteration to update your database.

Reporting
DeZign for Databases provides flexible, customizable reporting and printing capabilities.
HTML, MS Word and PDF reports. DeZign for Databases enables reporting and documentation of designs through generation of HTML, MS Word and PDF formatted reports for easy deployment of design information. Several reports with different levels of detail can be generated. Optionally the diagram can be inserted as a picture.
Export Diagram as Image. The diagram itself can be printed or exported as a bitmap, jpeg-image, gif-image or windows metafile.

System Requirements

requires a minimum of 16MB RAM and will run on a 486 processor. Disk space requirements is 10 MB.