I have been using PowerDesigner for a while, but I am starting to work with a newly formed team where some of the members are use to using ERwin and ER/Studio for their models. As part of this coming together we have chosen to use PowerDesigner going forward and have the ability to sit back and decide on how to do things as a team.
As part of this we have been discussing how to capture "Subject Areas" and "Security Data Classifications" for these new models. We have tentatively chosen to leverage the Package Feature in PowerDesigner to represent the "Subject Areas", since the Packages in PD behave like "Subject Areas" in ERwin. We are also looking to use the Stereotype attribute to capture the Security Classification of the data on Entities/Tables and Attributes/Columns in the Logical/Physical data models.
We looked at adding additional attributes to capture these attributes, but I have ran into issues in the past with them.
Does this look like a sound way to handle capturing this information? Show less