Chapter Six. Integrity Constraints


I've touched on the issue of integrity constraints at many points in preceding chap ters, but it's time to get more specific. Here first is a rough definition, repeated from Chapter 1: an integrity constraint (constraint for short) is basically just a boolean expression that must evaluate to TRUE. Constraints are so called because they constrain the values that can legally appear in some particular context. The ones we're interested in fall into two broad categories, type constraints and database constraints; in essence, a type constraint defines the values that constitute a given type, and a database constraint defines the values that can appear in a given database.

By the way, it's worth noting right away that constraints in general can be regarded as a formal version of what some people call business rules. I'll touch on this point again in the next chapter.



Database in Depth
Database in Depth: Relational Theory for Practitioners
ISBN: 0596100124
EAN: 2147483647
Year: 2006
Pages: 127
Authors: C.J. Date

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net