Chapter 8. Keys

 

         A fact in itself is nothing. It is valuable           only for the idea attached to it, or for                the proof which it furnishes.

 
 --Claude Bernard

Topics Covered in This Chapter

  • Why Keys Are Important

  • Establishing Keys for Each Table

  • Reviewing the Initial Table Structures

  • CASE STUDY

  • Summary

By now you've identified all the subjects that will be tracked in the database. You've also assigned fields to each table, thus defining its structure. Furthermore, you've put the structures through a screening process to control their makeup and quality. In this next stage of the database design process you'll begin the task of assigning keys to each table. As you'll soon learn, there are different types of keys, and each plays ...

Get Database Design for Mere Mortals 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.