Chapter 11

  1. 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. The two major types of business rules are database oriented and application oriented.

  3. No. Application oriented business rules impose constraints that you cannot establish within the logical design of the database.

  4. The two categories of database oriented business rules are field specific and relationship specific.

  5. A field specific business rule is one that imposes constraints on the elements of a field specification for a particular field.

  6. The constraint the business rule imposes is tested when you attempt ...

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.