|
|
|
CA ERwin DMV contains the following features:
The diagnostics are based on the rules of the relational model, including normalization issues relative to your database environment. Diagnostic results are conveniently organized into the following categories:
Changes to your database design are recommended based on the results of the diagnostics, providing an efficient and consistent approach to improving database design. In some cases, corrective scripts are automatically generated.
Several standard reports facilitate database design reviews within a project group. The Show Me facility isolates specific design issues within the context of large complicated models. This unique facility enhances productivity by eliminating the task of sifting through complicated database designs. By displaying only relevant database structures, this window provides modelers with a visual context for understanding and addressing the issues at hand. Modelers can also define a subset of the model and work with this subset.
The Teach Me facility can help novice database designers better understand the impact of their designs in light of Relational Theory and their particular database environment. This facility explains the problem and instructs the modeler on the implications of their design decisions. Use Teach Me to obtain more information about any specific diagnostic provided by CA ERwin DMV, as shown in the following diagram:
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |