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

Determining and Defining Business Rules

Determining and defining business rules is the fifth phase of the database-design process. During this phase, you'll hold interviews, identify limitations on various aspects of the database, establish business rules, and define and implement validation tables.

The manner in which your organization views and uses its data will determine a set of limitations and requirements that you must build into the database. Your interviews with users and management will help you identify the specific constraints you will impose on the data, data structures, or relationships. You then establish and document these specifications as business rules.

The interviews you conduct with users will reveal specific limitations ...