Reviewing and Refining Data Integrity
Reviewing data integrity is a simple task if you take a modular approach, that is, if you sequentially review each component of overall data integrity: table-level, field-level, and relationship-level integrity and business rules. If you have carefully followed the design method presented in this book, you should encounter very few problems here. The following sections briefly outline the points you should keep in mind as you conduct the review, and they contain references to earlier chapters in case you encounter any problems.
At the Table Level
In order to ensure that you've properly established table-level integrity, review each table and make certain that the table conforms to all of the following ...
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.
