Physical Modeling › 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 Rules dialog 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 Columns dialog. 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 Tables dialog. The validation rule that you attach to a table can check the values in two or more columns in a table simultaneously. For example, you can specify that rental_date <= due_date and attach this rule to a table using the Tables dialog.

More information:

Add a Validation Rule

Create a Valid Value List

Copy Valid Values from a Validation Rule

Assign Default or Validation Constraints to a Column or Attribute

How CA ERwin Data Modeler Generates Validation Rules

Validation Rules Dialog - Database Tab