A domain includes both logical and physical properties. When you work in a logical model, you work with just the logical properties of the domain: logical name, icon, datatype, validation rule, default value, definition, note, and logical user-defined property value. You can define these properties in the logical edit mode in the Domain Dictionary dialog. You can assign domains to attributes to enforce business decisions on datatype, and, if additional physical model characteristics are assigned to that domain, to speed the creation of a corresponding physical model.
All domains defined in the logical edit mode are added beneath the Domains icon in the Model Explorer. You can drag a Domains to an entity to create an attribute. The new attribute inherits all its properties from the domain. You can also assign a logical domain to an existing attribute in the Attributes dialog. The attribute inherits all its properties, except its name, from the domain. You can then change any properties in the Attributes dialog.
The following pre-defined domains are available in the logical model:
You can change the domain assignment for attributes at any point during a modeling session. You can also create domains that more clearly define the properties you want to assign to an attribute – or its corresponding column in the physical model. For example, if you want to indicate that an attribute represents money, you can create a Money domain and assign it to the attribute.
Every standard and user-defined domain is also available in the physical model, and can be used to define physical datatype and additional column properties, such as null option, display format, validation rule, or default value.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |