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.
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.