Chapter 10. Table Relationships

 

         There is no substitute for the comfort                  supplied by the utterly              taken-for-granted relationship.

 
 --Iris Murdoch

Topics Covered in This Chapter

  • Types of Relationships

  • Identifying Existing Relationships

  • Establishing Each Relationship

  • Establishing Relationship Characteristics

  • Relationship-Level Integrity

  • CASE STUDY

  • Summary

As you learned in Chapter 3, a relationship is a connection between a pair of tables. A relationship exists when the tables are connected by a Primary key and a Foreign key, or are linked together by a linking table; the manner in which the tables are connected depends on the type of relationship that exists between them.

A relationship is a crucial part of the database ...

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.

Start your free trial