By using the Check Model button in the toolbar, you can validate the model for errors. This works for both CDM and PDM models.
The validation results will be displayed in a list like this:
Model validation results
There can be "errors", "warnings" and "messages". The filter drop down box at the top of the results window let's you filter for a specific level of result message.
Automatic validation will be performed when you want to convert a CDM to a PDM and when you set the target database version in a PDM. In these cases, the validation results will only be shown where there are errors.
Possible errors and warnings in a CDM
The following are possible errors and warnings in a conceptual model.
|
Domain |
|
|
No name |
The domain has no name |
|
No datatype |
The domain has no data type specified |
|
||
|
Entity |
|
|
No name |
The entity has no name |
|
No attributes |
The entity has no attributes |
|
No identifying attributes |
The entity has no identifying attributes, which means that a single occurrence cannot be easily identified and no primary key constraint will be generated |
|
||
|
Attributes |
|
|
No name |
The attribute has no name |
|
No datatype |
The attribute has no data type specified |
|
||
|
Relationships |
|
|
Default source attributes |
The relationship has no attributes specified for the source, so it will use the default attributes |
|
Default destination attributes |
The relationship has no attributes specified for the destination, so it will use the default attributes |
|
No dominant role set |
The relationship is a one-to-one relationship, but no dominant role is specified, this can lead to an unwanted direction of the foreign key constraint when generating the PDM |
Possible errors and warnings in a PDM
The following are possible errors and warnings in a physical model, in addition to the database specific errors and warnings as normally raised when creating these objects.
|
Domain |
|
|
Datatype not supported |
A data type is used that is not supported in the database target version |
|
||
|
Column |
|
|
Datatype not supported |
A data type is used that is not supported in the database target version |