Review Questions

1.

What is a business rule?

2.

Name the two major types of business rules.

3.

Can you establish application oriented business rules within the logical design of the database?

4.

What are the two categories of database oriented business rules?

5.

What is a field specific business rule?

6.

When is a business rule tested?

7.

How do you document a business rule?

8.

State two advantages a Business Rule Specifications sheet provides.

9.

What is the purpose of the Action Taken section of a Business Rule Specifications sheet?

10.

What is the purpose of a validation table?

11.

What is the typical structure of a validation table?

12.

What is the association between a business rule ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.