13. Reviewing Data Integrity

When you have eliminated the impossible, whatever remains, however improbable, must be the truth.

—SHERLOCK HOLMES, THE SIGN OF FOUR

Topics Covered in This Chapter

Why You Should Review Data Integrity

Reviewing and Refining Data Integrity

Assembling the Database Documentation

Done at Last!

Case Study—Wrap-Up

Summary

You are now at the final stage of the database design process. You’ve accomplished many things since you started the process. Thus far you have

• Perceived the advantages of the relational database model and how it compares to other database models

• Created a mission statement for a new database

• Defined mission objectives for the new database

• Performed a complete analysis of an old database

• Identified ...

Get Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third 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.