Field-Level Integrity

This type of integrity ensures the following:

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

  • Field definitions are consistent throughout the database.

  • The values of a field are consistent and valid.

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

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.