newerLogo3WhyWhitemarshProductsAndServicesWhatsNewAboutWhitemarsh

Add Primary and Foreign Keys

A specification of relationship between a "parent" Table and a "child" Table is accomplished through a Primary Key and a Foreign Key.  Each relationship specification is named and described. The description should specify the business intent of the relationship. An important component of each relationship is Referential Integrity and the corresponding Referential Actions. The process to accomplish adding primary and foreign keys include:

  • Start the Operatioal Database Model Metabase System Module
  • Select the DBMS
  • Enter User Name and Password
  • Select the Menu Item, Keys, then subordinate menu item, Table Primary Keys
    • Select a Database
    • Select a DBMS Schema
    • Select an DBMS Table
    • Press Insert
    • Create Primary Key Name and Description
  • Select the subordinate menu item, Table Primary Key Columns
    • Select DBMS Schema
    • Select DBMS Table
    • Select and tag the DBMS Table Primary Key
    • Tag the DBMS Columns that belong to the DBMS Table Primary Key
    • Press the Build button
  • Select the subordinate menu item, DBMS Table Foreign Keys
    • Select the Database
    • Select DBMS Schema
    • Highlight the "Child" DBMS Table
    • Press Insert
    • Select the "Parent" DBMS Table Primary Key
    • Enter a short action phrase for the DBMS Table Foreign Key
    • Choose the Match Option
    • Choose the Referential Action Update and Delete Rule
    • Describe the purpose for the Foreign Key
    • Press the button that creates the Foreign Key

For Sales and Corporate: 1-301-249-1142 Whitemarsh@Wiscorp.com

Whitemarsh Information Systems Corporation

 Bowie, Maryland 20716 USA

Copyright 1981 - 2020 Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved