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