Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
by Michael J. Hernandez
Reviewing Data Integrity
The seventh and final phase in the database-design process involves reviewing the final database structure for data integrity.
First, you review each table to ensure that it meets the criteria of a properly designed table, and you check the fields within each table for proper structure. You then resolve any inconsistencies or problems you encounter and review the structures once more. After you've made the appropriate refinements, you check table-level integrity.
Second, you review and check the field specifications for each field. You make necessary refinements to the fields and then check field-level integrity. This review reaffirms the field-level integrity you identified and established earlier in the database-design ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access