Previous Topic: Database Design

Next Topic: Before You Install


Overview

CA ERwin DM combines a Windows-based graphical user interface with entity-relationship (ER) diagramming tools, and numerous innovative features. These features allow you to easily create and maintain your relational database and the logical and physical models that describe it. CA ERwin DM works by providing a design solution that helps you create a visual blueprint (a data model) for your organization.

CA ERwin DM is much more than a drawing tool. It not only helps you design a logical data model, which captures business rules and requirements, but it also supports the design of a corresponding physical data model for your target server. This enables you to forward engineer this physical data model and automatically generate physical database structures to your system catalog.

CA ERwin DM supports reverse engineering of existing databases and provides both a physical and logical/physical data model so you can maintain an existing database, or migrate from your current target server to a different one.

The Complete Compare technology automates model and database synchronization by letting you compare the model with the database, displaying, and analyzing the differences. This enables you to selectively move the differences into the model or generate them into the database.

ERwin database design overview diagram