Information Modeling Procedures and Standards

We are redoing our "Information Modeling Procedures and Standards." Please suggest where I may locate current standards for comparison. Of course, we need to meet the usual DoD Standards -

     FIPS PUB 184, Integration Definition For Information Modeling (IDEF1X). December 1993.
     DoD Manual 8320.1-M-1, DoD Data Standardization Procedures
     Defense Data Dictionary System (DDDS)

We are using ERwin and the target is currently Oracle 8.x.

I'm looking for something at a fairly detailed level. Something covering table/data element naming conventions, merging of data elements, normalization/denormalization, model documentation, ... Yet I don't want to just say -- be sure to meet all the applicable DoD standards.

For example, we already have the following -- I'm not sure of it's origin:

   Associative tables are used to document many-to-many relationships    between entities within a model and to relate the data in one model to    data in another. The associative table contains the hierarchical    foreign key of the primary, or parent, object and the non-hierarchical    foreign key of the second object, as well as any data element(s) whose    values are dependent on both keys.

The most useful information might (briefly) rehearse the applicable DoD standard and then go into some detail on the pragmatics which allow one to meet the standard in a reasonably efficient/effective way. That's what I think we really need.

Howard (remove abc to email) Received on Thu Jul 15 1999 - 09:47:42 CDT