# Complete Diagram

The complete diagram represents all the definitions, relationships and constraints using either an entity level or schema level diagram.

## Complete Schema Level Diagram

A complete schema level diagram for a single schema consists of:

- Each page is titled, with the title starting with the words: "Complete schema level diagram of ...";
- Each page is numbered in the form Page X of N, where N - total number of pages forming the diagram, and X - the particular page number;
- All schemas used are displayed;
- Entity, type, and simple symbols shall not be displayed;
- All schema-schema relationships, USE and REFERENCE, are displayed;
- The names of all definitions that are either used or referenced are attached to the relevant relationship line, together with any renames. If no names are attached to a relationship line, this is interpreted to mean that the entire schema is used or referenced.

To top

## Complete Entity Level Diagram

A complete entity level diagram for a single schema consists of:

- Each page shall have a title starting with the words: "Complete entity level diagram of ...";
- Each page is numbered in the form Page X of N, where N - total number of pages forming the diagram, and X - the particular page number;
- All entity data types, defined data types, and simple type symbols used within the single schema are displayed;
- Schema symblos do not appear;
- All relationships, attribute names, and cardinalities are displayed;
- All attributes, including explicit, derived and inverse attributes are displayed;
- All inheritance (subtype and supertype) relationships are displayed;
- All ABSTRACT SUPERTIPE constraints are marked;
- All ONEOF subtype relations are marked;
- All definitions used or referenced from another shcema are presented by the rounded box symbols, together with the surrounding rectangular boxes of the appropriate style (solid for used definitions and dashed for referenced definitions);
- Any rename is presented in the relevant inter-schema symbol;
- All entities that are constrained by a RULE are marked with an asterisk (*);
- All attributes that are constrained are marked with an asterisk (*);
- All defined types that are constrained are marked with an asterisk (*);
- All aggregation types that are constrained are marked with ah asterisk (*);
- All ABSTRACT ENTITY declarations are marked;
- All TOTAL_OVER constraints are marked;
- All relationships between extensible constructed data types and their extensions are displayed;
- All the new and old names of attributes during redeclaration are displayed;
- All GENERIC_ENTITY SELECT constraints are displayed;
- All GENERIC_ENTITY data types used within the schema are displayed.

To top

Copyright © 2005-2008 LKSoftWare GmbH. All Rights Reserved. JSDAI is a registered trade mark of LKSoftWare GmbH.