Re: How to add relationship lines?
At 07.05.2013 00:37, Michael Ross wrote: [...] I hear that being able to select multiple entities and change their properties altogether is coming (good when you want all the properties to be alike among the group). Do not trust rumors however. I wouldn't call the Dia 0.97 release announcement a rumor. Changing multiple properties at once was one of it's highlights. See: https://mail.gnome.org/archives/dia-list/2009-May/msg1.html But maybe I misunderstood the point you tried to make? Hans at Breuer dot Org --- Tell me what you need, and I'll tell you how to get along without it.-- Dilbert ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
Hans, Just that I don't keep up to date. Don't trust my rumors, because I am not in the revision mix. Thanks for bring forth the current news on this. On Wed, May 8, 2013 at 3:22 PM, Hans Breuer h...@breuer.org wrote: At 07.05.2013 00:37, Michael Ross wrote: [...] I hear that being able to select multiple entities and change their properties altogether is coming (good when you want all the properties to be alike among the group). Do not trust rumors however. I wouldn't call the Dia 0.97 release announcement a rumor. Changing multiple properties at once was one of it's highlights. See: https://mail.gnome.org/**archives/dia-list/2009-May/**msg1.htmlhttps://mail.gnome.org/archives/dia-list/2009-May/msg1.html But maybe I misunderstood the point you tried to make? Hans at Breuer dot Org --- Tell me what you need, and I'll tell you how to get along without it.-- Dilbert __**_ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/**mailman/listinfo/dia-listhttps://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia -- Put this question to yourself: should I use everyone else to attain happiness, or should I help others gain happiness? *Dalai Lama * To invent, you need a good imagination and a pile of junk. Thomas A. Edisonhttp://www.brainyquote.com/quotes/quotes/t/thomasaed125362.html A public-opinion poll is no substitute for thought. *Warren Buffet* Michael E. Ross (919) 550-2430 Land (919) 576-0824 https://www.google.com/voice/b/0?pli=1#phones Google Phone (919) 631-1451 Cell (919) 513-0418 Desk michael.e.r...@gmail.com michael.e.r...@gmail.com ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
On Mon, 6 May 2013 00:22:12 +0300 Genadi Saltikov carmaged...@gmail.com wrote: Thanks for the desire to help Alejandro, but this is missing the point, I specifically wanted ER Diagrams like here: http://img27.imageshack.us/img27/920/2013050542.jpg I must be missing something. I do diagrams like that all the time. I didn't understand your original question, nor the responses of most of the people, but it sounds to me like you want lines, either straight or jaggie between the boxes, circles, etc. Those are connectors, and there's an implied connection point in the center of every box, circle, etc. Thankfully, Hans has also replied to me giving me a link to the original diagram I missed, and from this I figured out how it works! Thanks Hans! :) So please share. What was the hangup, and how did you get around it? Only thing that might be missing (and not sure yet whether it is needed, will see later) - is the capability to assign more than just left or right Cardinality, as you call it - what if I want to assign a relationship to more than two Cardinalities? Do you mean which way the arrows go on the lines, or are you talking about something else, and if so, what? Thanks SteveT Steve Litt* http://www.troubleshooters.com/ Troubleshooting Training * Human Performance ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
Hello Steve! Apologies for not sharing what I found, I thought everyone on the list knows :) Basically, after dissecting the original .DIA file Hans linked me to, I figured out that the relationships like 1:1, 1:N etc, were defined as properties of the RELATIONSHIP objects! In my opinion, this is far from trivial, especially that it is not explained in the documentation. What I meant about cardinality, I have drawn in red color in the following picture, so you can see it without misunderstanding what I mean. https://www.dropbox.com/s/9asujpcd6o50nve/2013-05-06%2023.43.38.png Please note how this relationship relates to 3 entities - currently in Dia, I have not found a way to set more than 2. Finally a small (really small!) thing: When I double click an object to open its properties (usually only to write its name for start), it would make sense that hitting 'Enter' key, would press ok and close the properties window, without switching hand to mouse to do it - it will streamline the initial design phase :) I hope I've been clear, and provided some constructive ideas/questions :) Genadi. On Mon, May 6, 2013 at 11:01 PM, Steve Litt sl...@troubleshooters.comwrote: On Mon, 6 May 2013 00:22:12 +0300 Genadi Saltikov carmaged...@gmail.com wrote: Thanks for the desire to help Alejandro, but this is missing the point, I specifically wanted ER Diagrams like here: http://img27.imageshack.us/img27/920/2013050542.jpg I must be missing something. I do diagrams like that all the time. I didn't understand your original question, nor the responses of most of the people, but it sounds to me like you want lines, either straight or jaggie between the boxes, circles, etc. Those are connectors, and there's an implied connection point in the center of every box, circle, etc. Thankfully, Hans has also replied to me giving me a link to the original diagram I missed, and from this I figured out how it works! Thanks Hans! :) So please share. What was the hangup, and how did you get around it? Only thing that might be missing (and not sure yet whether it is needed, will see later) - is the capability to assign more than just left or right Cardinality, as you call it - what if I want to assign a relationship to more than two Cardinalities? Do you mean which way the arrows go on the lines, or are you talking about something else, and if so, what? Thanks SteveT Steve Litt* http://www.troubleshooters.com/ Troubleshooting Training * Human Performance ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
Genadi, The advantage of the properties box as it is now it is optional to shut down the properties box at all. If you call it up, you can set the properties, pick apply, dbl lmb a new entity and the properties are then applicable for the new entity. So you can save some mouse picks when you have a number of entities and properties to change. You do not have to hit close until you are done. You can leave the properties box open and it does not affect Diagramming. I hear that being able to select multiple entities and change their properties altogether is coming (good when you want all the properties to be alike among the group). Do not trust rumors however. On Mon, May 6, 2013 at 4:49 PM, Genadi Saltikov carmaged...@gmail.comwrote: Hello Steve! Apologies for not sharing what I found, I thought everyone on the list knows :) Basically, after dissecting the original .DIA file Hans linked me to, I figured out that the relationships like 1:1, 1:N etc, were defined as properties of the RELATIONSHIP objects! In my opinion, this is far from trivial, especially that it is not explained in the documentation. What I meant about cardinality, I have drawn in red color in the following picture, so you can see it without misunderstanding what I mean. https://www.dropbox.com/s/9asujpcd6o50nve/2013-05-06%2023.43.38.png Please note how this relationship relates to 3 entities - currently in Dia, I have not found a way to set more than 2. Finally a small (really small!) thing: When I double click an object to open its properties (usually only to write its name for start), it would make sense that hitting 'Enter' key, would press ok and close the properties window, without switching hand to mouse to do it - it will streamline the initial design phase :) I hope I've been clear, and provided some constructive ideas/questions :) Genadi. On Mon, May 6, 2013 at 11:01 PM, Steve Litt sl...@troubleshooters.comwrote: On Mon, 6 May 2013 00:22:12 +0300 Genadi Saltikov carmaged...@gmail.com wrote: Thanks for the desire to help Alejandro, but this is missing the point, I specifically wanted ER Diagrams like here: http://img27.imageshack.us/img27/920/2013050542.jpg I must be missing something. I do diagrams like that all the time. I didn't understand your original question, nor the responses of most of the people, but it sounds to me like you want lines, either straight or jaggie between the boxes, circles, etc. Those are connectors, and there's an implied connection point in the center of every box, circle, etc. Thankfully, Hans has also replied to me giving me a link to the original diagram I missed, and from this I figured out how it works! Thanks Hans! :) So please share. What was the hangup, and how did you get around it? Only thing that might be missing (and not sure yet whether it is needed, will see later) - is the capability to assign more than just left or right Cardinality, as you call it - what if I want to assign a relationship to more than two Cardinalities? Do you mean which way the arrows go on the lines, or are you talking about something else, and if so, what? Thanks SteveT Steve Litt* http://www.troubleshooters.com/ Troubleshooting Training * Human Performance ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia -- Put this question to yourself: should I use everyone else to attain happiness, or should I help others gain happiness? *Dalai Lama * To invent, you need a good imagination and a pile of junk. Thomas A. Edisonhttp://www.brainyquote.com/quotes/quotes/t/thomasaed125362.html A public-opinion poll is no substitute for thought. *Warren Buffet* Michael E. Ross (919) 550-2430 Land (919) 576-0824 https://www.google.com/voice/b/0?pli=1#phones Google Phone (919) 631-1451 Cell (919) 513-0418 Desk michael.e.r...@gmail.com michael.e.r...@gmail.com ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
On Mon, 6 May 2013 23:49:00 +0300 Genadi Saltikov carmaged...@gmail.com wrote: Hello Steve! Apologies for not sharing what I found, I thought everyone on the list knows :) Basically, after dissecting the original .DIA file Hans linked me to, I figured out that the relationships like 1:1, 1:N etc, were defined as properties of the RELATIONSHIP objects! I'd never used Dia's ER tools, so thanks for filling me in. After viewing Hans's diagram, I understand what you mean. Keep in mind I never took the course you're taking -- to me all I was drawing were flowcharts, hierarchy charts and block diagrams. :-) In my opinion, this is far from trivial, especially that it is not explained in the documentation. What I meant about cardinality, I have drawn in red color in the following picture, so you can see it without misunderstanding what I mean. https://www.dropbox.com/s/9asujpcd6o50nve/2013-05-06%2023.43.38.png Please note how this relationship relates to 3 entities - currently in Dia, I have not found a way to set more than 2. Now I understand. I'm wondering whether the ternary relationship described on that page of your book (and thanks for that -- it explained everything, including things I never knew before), really does justice to the true relationship between departments, locations and employees. I see it's a shorthand, but any two can relate totally without the third. When I've coded database apps from database tables, my recollection is I had a single relationship for exactly two tables, and then more relationships for other tables. See this diagram: http://www.a3b3.com/stuff/tri_relationship.dia If I had to write code based on the diagram, I'd find the explicit relationships more explicit. But then again, I've never been trained in what you're doing. Until now, that is, and thank you for that. Thank you for teaching me this brand new capability of Dia. I've used Dia over ten years, and never knew this existed. Anyway, please let me know what you think about the explicit tri-relationship. Thanks, SteveT Steve Litt* http://www.troubleshooters.com/ Troubleshooting Training * Human Performance ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
How to add relationship lines?
Hello! I've been trying Dia on Ubuntu 13.04 and it works great! I am doing ER Diagrams for various uni assignments in few courses. However, I cant figure out, nor find anything in the documentation about how to create relationships between objects such as 1:N, 1:* etc? As seen in this example: https://live.gnome.org/Dia/Examples?action=AttachFiledo=viewtarget=er-demo.png Thanks! ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
At 05.05.2013 15:39, Genadi Saltikov wrote: Hello! I've been trying Dia on Ubuntu 13.04 and it works great! I am doing ER Diagrams for various uni assignments in few courses. However, I cant figure out, nor find anything in the documentation about how to create relationships between objects such as 1:N, 1:* etc? As seen in this example: https://live.gnome.org/Dia/Examples?action=AttachFiledo=viewtarget=er-demo.png If it is in the sample maybe you should look at it's original diagram: https://git.gnome.org/browse/dia/plain/samples/ER-demo.dia Hans at Breuer dot Org --- Tell me what you need, and I'll tell you how to get along without it.-- Dilbert ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
Thanks for the desire to help Alejandro, but this is missing the point, I specifically wanted ER Diagrams like here: http://img27.imageshack.us/img27/920/2013050542.jpg Thankfully, Hans has also replied to me giving me a link to the original diagram I missed, and from this I figured out how it works! Thanks Hans! :) Only thing that might be missing (and not sure yet whether it is needed, will see later) - is the capability to assign more than just left or right Cardinality, as you call it - what if I want to assign a relationship to more than two Cardinalities? On Sun, May 5, 2013 at 7:50 PM, Alejandro Imass aim...@yabarana.com wrote: On Sun, May 5, 2013 at 9:39 AM, Genadi Saltikov carmaged...@gmail.com wrote: Hello! I've been trying Dia on Ubuntu 13.04 and it works great! I am doing ER Diagrams for various uni assignments in few courses. However, I cant figure out, nor find anything in the documentation about how to create relationships between objects such as 1:N, 1:* etc? I'll give you a better idea ;-) If you use UML class diagrams you can create SQL DDL directly with a program called dia2code. It will create Fk relationships and indexes automatically if the UML associations are set up correctly. Best, -- Alejandro Imass ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
Re: How to add relationship lines?
You might be able to superimpose and group two of opposite cardinality. On Sun, May 5, 2013 at 5:22 PM, Genadi Saltikov carmaged...@gmail.comwrote: Thanks for the desire to help Alejandro, but this is missing the point, I specifically wanted ER Diagrams like here: http://img27.imageshack.us/img27/920/2013050542.jpg Thankfully, Hans has also replied to me giving me a link to the original diagram I missed, and from this I figured out how it works! Thanks Hans! :) Only thing that might be missing (and not sure yet whether it is needed, will see later) - is the capability to assign more than just left or right Cardinality, as you call it - what if I want to assign a relationship to more than two Cardinalities? On Sun, May 5, 2013 at 7:50 PM, Alejandro Imass aim...@yabarana.comwrote: On Sun, May 5, 2013 at 9:39 AM, Genadi Saltikov carmaged...@gmail.com wrote: Hello! I've been trying Dia on Ubuntu 13.04 and it works great! I am doing ER Diagrams for various uni assignments in few courses. However, I cant figure out, nor find anything in the documentation about how to create relationships between objects such as 1:N, 1:* etc? I'll give you a better idea ;-) If you use UML class diagrams you can create SQL DDL directly with a program called dia2code. It will create Fk relationships and indexes automatically if the UML associations are set up correctly. Best, -- Alejandro Imass ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia -- Put this question to yourself: should I use everyone else to attain happiness, or should I help others gain happiness? *Dalai Lama * To invent, you need a good imagination and a pile of junk. Thomas A. Edisonhttp://www.brainyquote.com/quotes/quotes/t/thomasaed125362.html A public-opinion poll is no substitute for thought. *Warren Buffet* Michael E. Ross (919) 550-2430 Land (919) 576-0824 https://www.google.com/voice/b/0?pli=1#phones Google Phone (919) 631-1451 Cell (919) 513-0418 Desk michael.e.r...@gmail.com michael.e.r...@gmail.com ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia