Design menu option missing [message #629288] |
Fri, 05 December 2014 10:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
aliyesami
Messages: 28 Registered: October 2005 Location: Florida
|
Junior Member |
|
|
i have two issues :
1) i installed the 4.0.3.853 oracle sql developer data modeller but I dont see the "DESIGN" menu option ?
i am trying to convert a logical model to physical model .
2) for identifying or non-identifying relationship its showing the same DDL , its not compounding the primary key of the child entity with the primary key for parent.
I am selecting identifying/non-identifying relationship by checking/unchecking "Source Optional" check box in "Relation Properties"
please see the following oracle document fig 1-1 showing the design menu option :
https://docs.oracle.com/cd/E15276_01/doc.20/e13677/data_modeling.htm
thanks
|
|
|
|
|
Re: Design menu option missing [message #629293 is a reply to message #629292] |
Fri, 05 December 2014 15:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
aliyesami
Messages: 28 Registered: October 2005 Location: Florida
|
Junior Member |
|
|
also can you please create a many-to-many relationship in oracle datamodeller and generate the DDL for optional and non optional relationship and see if if the DDLs are different? for me the DDLs are the same.
|
|
|
|
|