Database Reference
In-Depth Information
include letters, so you must make the following modifications to these elements in order to
impose the constraints defined by this rule.
1.
Change the Data Type setting to “Alphanumeric.”
2.
Include “Letters” under the Character Support element.
3.
Modify the Display Format element to ensure that the letters in Canadian zip codes
will be capitalized.
ations.
Figure 11.3. Establishing a field-specific business rule for C
UST
Z
IPCODE
Relationship-Specific Business Rules
Thesetypesofbusinessrulesimposeconstraintsthataffectthecharacteristicsofarelation-
ship. For instance, assume you're working with the tables and relationships in
Figure 11.4
.
Figure 11.4. Tables and relationships from a school database
