I’ve created a data model through following movie link
TDM32_ReverseEngineering_HTMLReports.htm.
Well, though, I am able to create a data model and ER Diagramme, but I am not able sure, weather it is OK or not ? I’ve useed the table DDL script to genrate Data Model and ER Diagramme. After generating the physcial data model using report sections. I’ve got few questiosns to ask to you. I would appriciate , if you can go through and comment on those. Please find the attached document.
You can test your model if you have Expert mode enabled.Then you can right click on model name in Application view or in Model explorer and from menu left click on Test model.
Thanks Tomas, I’ll reattach that one.One more thing TOMAS that if I need to create a only ER Diagramme from Scripts , Can I also do that sepereatly or Is there any way that, If I need to generate ER Diagramme and make it to write into RTF File.
Please find attached a reply to your questions in the doc.
if I need to create a only ER Diagramme from Scripts , Can I also do that sepereatly or Is there any way that, If I need to generate ER Diagramme and make it to write into RTF File.
Regarding generation of ERD into RTF report, it is not possible. Please generate HTML report for your ERD or feel free to import the ERD into image (File | Export to Graphic File).
If you have any questions, please write me back. Thanks.
In the Entity Properties form, Keys tab, there is a PK by default. It is not possible to delete this PK, however by default it is empty. If you already added an attribute to this PK, you need to edit the PK and in the Key Properties dialog | Attributes tab, remove the attribute from the box Selected – use the < arrow.
Thanks for the code. Here are possible solutions:
If you want to have a PK only with the attribute allocationld, add the PK there and do NOT select the Unique checkbox in the property dialog of this attribute.
If you want to have only unique index with attribute allocationld instead of the PK, you have the following possibilities:
a) Create a new AK on the Keys tab and add the allocationld attribute to this newly created key. OR
b) Edit the attribute allocationld and on tab General of the Attribute Property dialog select the Unique checkbox. -> This step is the same as a) where the same was done automatically. OR
c) In the Entity Properties form | Indexes tab create a new index. Edit it and:
on tab General select the Unique checkbox and
on tab Items, select the allocationld attribute.
All the three solutions will result into the same – in MySQL a unique index will be created.
Later you can select a linking method for the relationship:
Through a Key (Primary or Alternate key) of parent entity
Through Unique Index of parent entity
How to Set Up Linking Method
Double-click the selected relationship.
Click the Foreign Keys tab.
From the Parent Key box, select the appropriate linking method.
If you have more questions, please write me back. Thanks.
