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 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.
