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 Implemented 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 Schema
• Select an Table
• Press Insert
• Create Primary Key Name and Description
• Select the subordinate menu item, Table Primary Key Columns
• Select Schema
• Select Table
• Select and tag the Primary Key
• Tag the Columns that belong to the Primary Key
• Press the Build button
• Select the subordinate menu item, Table Foreign Keys
• Select Schema
• Highlight the "Child" Table
• Press Insert
• Select the "Parent" Table Primary Key
• Enter a short action phrase for the 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 - 2024 Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved