 |
 |
 |
 |
 |
 |
 |
 |
 |
| • |
Each
table must have a unique two-letter abbreviation ttabbr:
|
|
|
| • |
Each
TTabbrev produces a primary key (pkey) attribute:
|
|
|
| • |
Each
1:M relationship produces a foreign key (fkey);
|
|
|
| • |
Attribute
formats and descriptions must also be acquired:
|
|
|
These
are added on this diagram or directly to file StateModel.sch,
|
|
|
which comprises a Data Dictionary of entities,
classes, relations and
|
|
attributes.
|
|
|
| • |
This
state model belongs to the LCP namespace subschema,
|
|
|
which
also includes Tables AC, AI and EI
|
|