DeZign for Databases

Description

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, 12Better 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.

Database - Design - Software - Data - Modeling - Tool - Er Diagram - Er - Diagram - Diagramming - Entity - Relationship - Case - Development - Erd - Model

Published By:datanamic.com

License Type:Shareware

Date Added:04 September, 2012

Version:7.2

Downloads:14

Size:6.9 MB

Platform: Macintosh

More downloads from datanamic.com

DB Zipper is a database tool that processes table data and table structures from any database into a compressed database archive file (*. dbz)

DateSep 25, 2014

Authordatanamic.com

Size:3.4 MB

LicenseShareware

PlatformMacintosh

CategoryDatabases & Tools

DB Data Generator is a simple, strong data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes

DateSep 25, 2014

Authordatanamic.com

Size:3.0 MB

LicenseShareware

PlatformMacintosh

CategoryDatabases & Tools

What people say
- required fields
     
Related Downloads

1st Subscription Manager - is a simplest, way to extract business emails from your regular POP 3 mailbox.

DateSep 25, 2014

AuthorEmailarms

Size:624.0 KB

LicenseFreeware

Price:Free

PlatformWin98, WinME, WinNT 3.x, WinNT 4.x

CategoryE-Mail List Management

1st Subscription Manager

Desktop locking security utility to protect desktop when you are not near PC. Password protection can be automatically activated on boot or with a click of an icon in the system tray. Log access attempts and enforce a custom background image.

DateSep 25, 2014

AuthorPC-Safety

Size:801.0 KB

LicenseShareware

Price:$29.00

PlatformWin98, WinME, WinNT 3.x, WinNT 4.x

CategoryAccess Control

Access Controller

With AdeptSQL Diff, you can visually compare two MS SQL Server databases, then produce and execute difference scripts for a choosen part or for the whole schema. Also compares table data. Very fast and easy to operate..

DateSep 25, 2014

AuthorAdept SQL Tools

Size:1.3 MB

LicenseCommercial

Price:$240.00

PlatformWin98, WinME, WinNT 4.x, WinXP

CategoryDatabases & Tools

AdeptSQL Diff 1.96 Build

Advanced DBF Editor is a viewer and editor for dbf databases. Designed for advanced users, the program enables you to open dbf database and edit and export its records without the need to buy several dedicated database creation tools.

DateSep 25, 2014

AuthorAdvanced DBF Editor Team

Size:1.0 MB

LicenseShareware

Price:$39.95

PlatformWindows, Win2000, WinVista, WinVista x64

CategoryDatabases & Tools

Advanced DBF Editor

Advanced DBF Repair (ADR) is a powerful tool to repair corrupt DBF files. It can scan the corrupt DBF files and recover your data in them as much as possible, so to minimize the loss in file corruption.

DateSep 25, 2014

AuthorDBF Repair, Inc.

Size:941.0 KB

LicenseDemo

Price:Free

PlatformWin95, Win98, WinME, WinNT 3.x

CategoryDatabases & Tools

Advanced DBF Repair