Now that we’ve finalized our physical data model, we’ll want to create a physical database from it through forward engineering. Before we generate any code, however, we’ll want to validate our model to make sure that it will generate valid SQL structures for the database. CA ERwin Data Modeler has a process called Check Model which allows us to do a validation of the physical model before we reverse engineer. To run this validation, select Actions|Forward Engineer|Check Model from the Main Menu. A model validation report will be generated, as shown in Figure 19.79, which alerts you to any design errors in the model that will affect forward engineering[19].

Figure 19.79 Model Validation Report

Our validation showed no errors ...

Get Data Modeling Made Simple with CA ERwin Data Modeler r8 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.