Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Summary

We began this chapter with a discussion of the importance of completing the design process, and you learned that designing a database without the benefit of a good design method leads to poor and improper design. We also discussed the fact that the level of structural and data integrity is in direct proportion to how thoroughly you follow the design process. You then learned that inconsistent data and inaccurate information are two problems typically associated with poorly designed databases.

Next we looked at an overview of the entire database-design process. The process was consolidated into the following phases in order to provide you with a clear picture of the general steps involved in designing a database:

1. Define a mission ...