Chapter 10. Table Relationships
There is no substitute for the comfort supplied by the utterly taken-for-granted relationship.
Topics Covered in This Chapter
Types of Relationships
Identifying Existing Relationships
Establishing Each Relationship
Establishing Relationship Characteristics
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 ...