Erwin Subject Area membership list:
Based on the subject area membership list, there are 5 subject area defined. We can follow the logical design and create 5 entities for the metadata schema accordingly with their corresponding tables in the subject area document.
- Acccount Delegate
- Asset
- Purchasing
- GL
- Security
We are assuming that all metadata management tool would require some sort of design of metadata schema, with defined entities and their corresponding tables and attributes
according to reach some sort of minimal metadata standards.
Erwin physical dicrtionary download example: - GLPhysical Dictionary.xls
- In order to render this tool useful for creating the data dictionary and ease of future extraction into databases and portablilty into different metadata management software, it needs to be able to grab data type, and other important attributes (such as PK,FK, and AK), descriptions, etc.