DBDesigner 4, an ERD with a multirelational MCD
dgm
Posted messages
2
Status
Member
-
darktemplar -
darktemplar -
Hello,
I am working on a design with the Merise method. I made my MCD with Power AMC, but I couldn’t make my MLD with the same tool.
I downloaded DBDesigner 4, and I created my MLD.
However, I have a problem: with DBDesigner I can’t represent ternary relationships. I have three tables in relation; how can I represent that using DBDesigner4?
Can someone help me ???? I don’t really know what to do anymore
I am working on a design with the Merise method. I made my MCD with Power AMC, but I couldn’t make my MLD with the same tool.
I downloaded DBDesigner 4, and I created my MLD.
However, I have a problem: with DBDesigner I can’t represent ternary relationships. I have three tables in relation; how can I represent that using DBDesigner4?
Can someone help me ???? I don’t really know what to do anymore
Configuration: Windows XP Firefox 2.0.0.11
5 answers
If your MCD looks like this
https://www.cjoint.com/?bCnfdm3JWl
Your MLD should look like this
https://www.cjoint.com/?bCngKx2g31
Links valid for 21 days
https://www.cjoint.com/?bCnfdm3JWl
Your MLD should look like this
https://www.cjoint.com/?bCngKx2g31
Links valid for 21 days
hi dandy punk
Thanks for your post. Your images are really interesting, they’re exactly what I want to achieve. However, I have on one side (1,n) and on the other two (1,1) and (1,1).
what tools did you use to make that?
surely not DBDesigner, nor Power AMC. My real problem is representing the relationship (which is not possible with DBDesigner), I would need it to write the technical documentation.
I would be delighted to know with which tool you made that. see you later
Thanks for your post. Your images are really interesting, they’re exactly what I want to achieve. However, I have on one side (1,n) and on the other two (1,1) and (1,1).
what tools did you use to make that?
surely not DBDesigner, nor Power AMC. My real problem is representing the relationship (which is not possible with DBDesigner), I would need it to write the technical documentation.
I would be delighted to know with which tool you made that. see you later
I work with Windev XI, which, according to some opinions, is not MERISE-compatible.
AMC Designer (formerly Power AMC) used to allow the “transfer” MCD-MPD
Send me your MCD and I’ll try to see. I would like to see your MCD
----------------------------------------------------------------------------------------
Sorry Arnaud Rosfcheld, Armelle Le Gueven I no longer use MERISE intensely
You taught it to me so well that for me it’s normal
AMC Designer (formerly Power AMC) used to allow the “transfer” MCD-MPD
Send me your MCD and I’ll try to see. I would like to see your MCD
----------------------------------------------------------------------------------------
Sorry Arnaud Rosfcheld, Armelle Le Gueven I no longer use MERISE intensely
You taught it to me so well that for me it’s normal
If you have a relationship that is not in 1:N in the MCD, it means you haven’t pushed your analysis far enough. In Merise, non-1: n relationships must be transformed into binary relations. The only exception could be the case of a triple relationship where a Date or Time table was included, because this table would disappear and be transformed into fields in the MLD, which would make the relationship binary.
I am blocked. Actually, I don’t know how to design a logical data model (LDM) or a relational model with UML (UML diagram).
Thank you for helping me.