Database Reference
In-Depth Information
Field-Level Integrity
You can ensure that you've properly established field-level integrity after you've done the
following:
• Made sure each field conforms to the Elements of the Ideal Field
• And made certain you've defined a set of field specifications for each field
You can resolve field-level integrity problems with the techniques discussed in
Chapter 9
,
Relationship-Level Integrity
Examine each table relationship to ensure that you've properly established relationship-
level integrity. You've achieved this level of integrity when you've completed these tasks:
• Properly established the relationship
• Defined the appropriate deletion rules
• Correctly identified the type of participation for each table
• And established the proper degree of participation for each table
Ifyouidentifyaproblemwitharelationship,usethetechniquesin
Chapter10
,
“
TableRela-
tionships
,” to resolve it.
Business Rules
You can ensure that your business rules are sound by making certain these tasks are com-
plete.
• You're sure that each rule imposes a
meaningful
constraint.
• You've determined the proper category for the rule.
• You've properly defined and established each rule.
• You've modified the appropriate field specification elements or table relationship
characteristics.
• You've established the appropriate validation tables.
• You've completed a Business Rule Specifications sheet for each rule.
If you encounter problems with any of your business rules, refer to
Chapter 11
, “
Business
Rules
,” for the techniques necessary to solve them.
