Generating the physical model

To generate the physical model, carry out the steps shown in Figure 9.

Figure 9. The "Generate physical model" command

Steps:

1. Right-click on the "Library" package.

2. Run the "MDACs/SQL Designer/Generate physical model" command.

The same operation can be carried out in the "SQL" tab of the auxiliary window, as shown in Figure 10.

Figure 10. Creating the physical model in the "SQL" tab of the auxiliary window

Steps:

1. Select the "Library" package in the explorer.

2. Select the "SQL" tab in the auxiliary window.

3. Click on the button.

Whichever method is used, the physical model is then generated. A diagram is automatically generated (as shown in Figure 11), if the "Generate diagram with physical model" parameter is active.

Figure 11. The diagram automatically generated for the physical model

Each class of the physical model represents a relational table, and is stereotyped <<table>>.

Each association 1..* or * is transformed into an association table.

The generator takes into account the following association navigability rules:

· The source table primary keys are copied into the destination table.

· A foreign key is added to the source table primary key. This mentions the destination table, the destination table’s primary key to be bound and the name of the foreign key.

· An association named using the FK name for your information is generated.