newerLogo3

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

2008 Althea Lane Bowie, Maryland 20716 USA

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