Chapter 11

   

---

1:	What is a business rule ?
A1:	A business rule is a statement that imposes some form of constraint on a specific aspect of the database, such as the elements within a field specification for a particular field or the characteristics of a given relationship.
2:	Name the two major types of business rules.
A2:	The two major types of business rules are database oriented and application oriented .
3:	Can you establish application oriented business rules within the logical design of the database?
A3:	No. Application oriented business rules impose constraints that you cannot establish within the logical design of the database.
4:	What are the two categories of database oriented business rules?
A4:	The two categories of database oriented business rules are field specific and relationship specific .
5:	What is a field specific business rule ?
A5:	A field specific business rule is one that imposes constraints on the elements of a field specification for a particular field.
6:	When is a business rule tested ?
A6:	The constraint the business rule imposes is tested when you attempt to perform one of three actions: inserting a record into the table or an entry into a field, deleting a record from the table or a value within a field, or updating a field's value.
7:	How do you document a business rule?
A7:	You document a business rule by filling out a Business Rule Specifications sheet for the rule.
8:	State two advantages a Business Rule Specifications sheet provides.
A8:	The Business Rule Specifications sheet provides three advantages: It allows you to document every database oriented business rule. It allows you to document every application oriented business rule. It provides a standard method for recording all business rules.
9:	What is the purpose of the Action Taken section of a Business Rule Specifications sheet?
A9:	The Action Taken section of a Business Rule Specifications sheet is the area where you indicate the modifications you've made to the elements of a field specification or to a relationship diagram.
10:	What is the purpose of a validation table ?
A10:	A validation table (also known as a lookup table ) stores data that you specifically use to implement data integrity.
11:	What is the typical structure of a validation table?
A11:	Validation tables usually (but not always) comprise two fields: The first acts as the primary key and is what you'll use to help you enforce data integrity, and the second is simply a non-key field that stores a set of values required by some other field in the database.
12:	What is the association between a business rule and a validation table?
A12:	You can use a validation table to enforce a constraint that a business rule imposes on a given field's range of values.
13:	Why should you review all of your completed Business Rule Specifications sheets?
A13:	You should review each Business Rule Specifications sheet to ensure that you've properly established the rule it records and that you've clearly marked all of the appropriate areas on the sheet.

---

Top