annadatabhaskarsubramanyam
asked on
[urgent] ORACLE STANDARD ER DIAGRAMS
I am looking for a url where I can understand the oracle standard of drawing er diagrams.
I want to draw er diagrams using this standard.
please help
also reply by mail to annadata@myrealbox.com plz
thanx
I want to draw er diagrams using this standard.
please help
also reply by mail to annadata@myrealbox.com plz
thanx
ASKER
i tried searching... something concrete plz
What do you mean by the standard?
Oracle Designer will generate ER diagrams in a certain fashion based on your tables, relations, etc.
It uses certain symbols to represent primary Keys, Foreign Keys, Unique Keys, Not Null fields, etc. The newest version of designer indicates datatypes as well.
Common usage for simple diagrams avoids dead crows (i.e. do not have a many to one relationship represented with the child above the parent).
Or are you attempting to create Oracle ERDs with another tool (such as Visio)?
regards,
JT
Oracle Designer will generate ER diagrams in a certain fashion based on your tables, relations, etc.
It uses certain symbols to represent primary Keys, Foreign Keys, Unique Keys, Not Null fields, etc. The newest version of designer indicates datatypes as well.
Common usage for simple diagrams avoids dead crows (i.e. do not have a many to one relationship represented with the child above the parent).
Or are you attempting to create Oracle ERDs with another tool (such as Visio)?
regards,
JT
PS I've got a good book on designing databases using CASE(Oracle Des2K).
Let me know if you want the details.
JT
Let me know if you want the details.
JT
ASKER
This is particularly for HENKA...
The diagrams in the pdf file u suggested, use a particular notation. That is what my friend calls Oracle standard....
I want to know how to draw diagrams using that standard. Hope u understand!!!
The diagrams in the pdf file u suggested, use a particular notation. That is what my friend calls Oracle standard....
I want to know how to draw diagrams using that standard. Hope u understand!!!
I think that a Tutorial and an Designer on-line help (Modeling entities and their relationship -> Introducing the Entity Relationship Diagrammer -> How to model entities ) would help you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ps...forget the pictures above...(the ones I tried to draw...they look nothing like they did before I pressed the submit button!
But the website is good!
Regards,
JT
But the website is good!
Regards,
JT
__ 1 M__
| |__/\__| |
|__| \/ |__|
| |__/\__| |
|__| \/ |__|
hmmm...curious the way it changes wha the post looks like...
If you copy the diagram and paste it into the comment box, it looks normal...
If you copy the diagram and paste it into the comment box, it looks normal...
ASKER
thanks for all the help dear friends...
Jtrifts was very informative in his comment....
ASKER
thanx bud..
u r welcome!
regards,
JT
regards,
JT
try technet.oracle.com