Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Summary

This chapter opened with a definition of business rules. You learned that a business rule is a constraint imposed on a field or a relationship that is based on the way the organization perceives and uses its data and that it is derived from the manner in which the organization functions or conducts its business. You now know that there are two major types of business rules: database oriented and application oriented. Although our focus here is on database oriented business rules, you know that you can at least record the basic elements of application oriented business rules for use later in the implementation process.

You then learned that database oriented business rules are divided into two categories: field specific business rules, ...