Home » SQL & PL/SQL » Client Tools » Data Dictionary (Data Modeler) (Oracle SQL Data Modeler)
Data Dictionary (Data Modeler) [message #637514] Tue, 19 May 2015 07:57
fluffycone
Messages: 27
Registered: June 2011
Junior Member
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:

Attribute: DataDictionary
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?

Attribute: DataDictionary
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.

Attribute: DataDictionary
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.

Thanks,
Previous Topic: How to open Logical Model?
Next Topic: connection problem
Goto Forum:
  


Current Time: Sun Feb 18 13:16:55 CST 2018

Total time taken to generate the page: 0.00970 seconds