Generate Data Model Tree

An Operational Database Data Model "data" that is stored in a DBMS Schema, DBMS Tables, DBMS Columns, and Keys can be used to generate a data model tree diagram. This diagram shows a data model tree that is based on a selected root-DBMS Table and then displays ancestor and descendant DBMS Tables as tree branches. Each DBMS Table on a branch is colored coded to represent whether the DBMS Table is an ancestor, a descendant, subtyped, or recursive. The process to accomplish the generation of the SQL DDL includes:

• Start the Implemented Database Model Metabase System Module
• Select the DBMS
• Enter User Name and Password
• Select the Menu Item, DBMS Schema and DBMS Tables, then the subordinate item, Data Model Tree
• Highlight the appropriate DBMS Schema
• Select the DBMS Table around which the data model hierarchy is to be created.
• Press the Display Operational Database Model Diagram
• When the tree is displayed, the various DBMS Tables can be selected which, in turn, displays
• DBMS Table columns and definitions
• Primary key, DBMS Columns and definitions
• Foreign key, DBMS Columns and definitions

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