OraFAQ Forum: Client Tools » Data Dictionary (Data Modeler)

Home » Other » Client Tools » Data Dictionary (Data Modeler) (Oracle SQL Data Modeler)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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,

Report message to a moderator

Previous Topic:	How to open Logical Model?
Next Topic:	connection problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 23:23:03 CST 2024