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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.