Diagram Conventions

Figure 2-6: Foreign Keys


Another kind of attribute is a foreign key. A foreign key is a primary key from another entity that points to a record in the related entity.

For example, the related entity between Corner and Boundary is Corner Boundary, shown below in Figure 2-6 from the Cadastral Data Content Standard.

Within Corner Boundary are two foreign keys. One is Corner ID which points to an entry in the Corner entity and the other is Boundary ID which points to an entry in Boundary. The entity Corner Boundary describes which corners are attached to which boundaries.

foreign keys

Figure 2-6 Foreign Keys


This ends the sequence of pages describing the entity relationship diagram conventions. Now, using the links below, return to Section 4, which led to the topic on this page, or go to any of the other Sections or Modules.


Links to the Course Sections and Modules: [Quick Reference] [Introduction] [Section 1: Purpose and Benefits of the Cadastral Data Content Standard] [Section 2: How the Standard Was Developed] [Section 3: Other Standards and Related Activities] [Section 4: Data Modeling Techniques, Rules and Diagram Conventions] [Section 5: Crosswalks, Translations, and Examples] [Section 6: Understanding Compliance with the Standard] [Section 7: Maintenance of the Standard] [Section 8: User and Technical Support] [County Recorder Module] [GIS Specialist Module] [Surveyor Module] [Glossary]


Learning the Cadastral Data Content Standard

Home

Presented by the United States Department of the Interior Bureau of Land Management, and

the Federal Geographic Data Committee Cadastral Subcommittee