Not sure if this is the correct forum for my question, but I do not know where else to go. If there is another resource, please advise.
I have a question about how to develop the Data Dictionary. For example, I have several tables that I need to generate a unique ID (for Primary Keys). Should I create a data dictionary item for each Unique ID as below:
Customer ID: Customer ID (Numeric)
Employee ID: Employee ID (Numeric)
Product ID: Product ID (Numeric)
OR should I create one Data Dictionary Definition to use for multiple items?
Customer ID: Unique ID (Numeric)
Employee ID: Unique ID (Numeric)
Product ID: Unique ID (Numeric)
AND I have the same question for attributes like First Name, Last Name, Middle Name, Company Name. Would the following be the appropriate solution OR should I create a Data Dictionary definition for each type of name.
First Name: Name (VARCHAR2(25))
Last Name: Name (VARCHAR2(25))
Company Name: Name (VARCHAR(25))
AND I had another example, but it has slipped my mind for the moment.