Chapter 9

  1. Field specifications are important for these reasons:

    a. They help establish and enforce field-level integrity.

    b. They help enhance overall data integrity.

    c. They compel you to acquire a complete understanding of the nature and purpose of the data in the database.

    d. They constitute the “data dictionary” of the database.

  2. Field-level integrity warrants the following:

    a. The identity and purpose of a field is clear, and all of the tables in which it appears are properly identified.

    b. Field definitions are consistent throughout the database.

    c. The values of a field are consistent and valid.

    d. The types of modifications, comparisons, and operations that can be applied to the values in the field are clearly identified.

  3. The three ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.