Home | Previous Page | Next Page   Appendix A. The stores_demo Database >

Primary-Foreign Key Relationships

The tables of the stores_demo database are linked by the primary-foreign key relationships that Figure 6 shows and are identified in this section. This type of relationship is called a referential constraint because a foreign key in one table references the primary key in another table. Figure 7 through Figure 14 show the relationships among tables and how information stored in one table supplements information stored in others.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]