Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design

Select a table.

Review each field and determine whether it requires any constraints.

Define the necessary business rules for the field.

Establish the rules by modifying the appropriate field specification elements.

Determine what actions test the rule.

Record the rule on a Business Rule Specifications sheet.