Creating Models › Creating a Physical Model › Validation Rules

Validation Rules

You can create validation rules to enforce the business rules of your organization. The rules that you create can establish a value, a list of values, or a range of acceptable values to store in a table, column, entity, or attribute. Use the Validation Rule Editor to create rules.

For example, you can create a validation rule that lists: Comedy, Drama, Mystery, Horror, New Releases, Foreign, Science Fiction as valid values for a column named movie_genre. You can then attach this rule to one or more columns using the Table Column Editor. Then you can check that only these valid values are entered in these columns.

To assign a validation rule to a table, you can use the Validation tab in the Table Editor dialog. The validation rule that you attach to a table can simultaneously check the values in two or more columns in a table. For example, you can specify that rental_date <= due_date and attach this rule to a table using the Table Editor.

More information:

Add a Validation Rule

Create a Valid Value List

Copy Valid Values from a Validation Rule

Assign Default and Validation Constraints to a Column

How CA ERwin Data Modeler Generates Validation Rules