O'Reilly logo

Absolute Beginner’s Guide to Databases by John V. Petersen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implement Field-Level Rules

Before delving into how field-level validation is implemented, a study of the relevant field-level properties that support validation must be undertaken. In Chapter 2, “The Anatomy of a Real Database,” you were briefly introduced to these properties. In this chapter, you will be introduced to how these properties actually work to help enforce data integrity.

Field-Level Properties

Figure 6.1 illustrates the various properties of the ClientType field of the Client Table. Depending on how you want to configure your rules, you may use some or all the properties. Depending on the field data type, some properties may not apply. For example, the Allow Zero Length property would apply only to a text field and the Decimal ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required