Data Base Designer

Data Base Designer transforms the Information Model constructed using ProMod-PLUS into the data structure of a data base. In this way the final phases of design, implementation and testing of data base applications are supported.

Target data base. Click on one of the DBMS names in the list to choose the target data base.

Include Prolog. Include the prolog at the start of the script. To create the prolog use the Annotate Project command.

Include Epilog. Include the epilog at the end of the script. An epilog that is created for an individual Entity or Relationship is always included. To create the epilog use the Annotate Project command.

Store Results in Project Library.  If you click on this option then the parts of the script corresponding to individual Entities and Relationships are additionally stored in the project library with the objects. If you choose this option then you will be able to "View SQL" from the Entity/Relationship Editor.

Table owner. The table owner name given here is prefixed to each table name generated. This can be overridden by the defining a "User name" for a particular Entity or Relationship in the data base definitions.

SQL script file pattern.  Specify a pattern for the name of the script file for each object. $o is replaced at run-time by the name of the object.

SQL drop file pattern. Specify a pattern for the name of the drop file for each object. $o is replaced at run-time by the name of the object.