Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition

11. Business Rules

You are remembered for the rules you break.

—GENERAL DOUGLAS MACARTHUR

Topics Covered in This Chapter

What Are Business Rules?

Categories of Business Rules

Defining and Establishing Business Rules

Validation Tables

Reviewing the Business Rule Specifications Sheets

Case Study

Summary

Review Questions

Throughout the database design process, you’ve performed tasks that helped to establish various levels of data integrity. You’ve established table-level integrity, field-level integrity, and relationship-level integrity thus far. In doing so, you’ve ensured that the table and field structures are sound, that data entered into the fields will be consistent and basically valid, and that relationships are meaningful and properly established. ...