Chapter 9. Field Specifications

 

           It has long been an axiom of mine          that the little things are infinitely the                       most important.

 
 --Sherlock Holmes, The Adventures of Sherlock Holmes

Topics Covered in This Chapter

  • Why Field Specifications Are Important

  • Field-Level Integrity

  • Anatomy of a Field Specification

  • Defining Field Specifications for Each Field in the Database

  • CASE STUDY

  • Summary

Fields are the bedrock of the database. They represent characteristics of the subjects that are important to the organization. They store the data that is retrieved and then presented as information—information that is vital to the organization's daily operations, success, and future growth. They are the most overlooked, underutilized, ...

Get Database Design for Mere Mortals 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.