Recent Posts

Pages: 1 [2] 3 4 ... 10
General Board / Re: Logical Data Modelling in SPARX
« Last post by Richard Freggi on October 21, 2018, 01:10:10 am »
Just a few 2c

A logical data model is implementation-independent (as-in: RDBMS independent) by definition.  If there is a RDBMS-specific item, then it's a physical data model.  The idea of logical data model is high reusability and easy extension to whatever technology is chosen for implementation (+robust against mid-project IT architecture changes)

A UML class diagram is a superset of data model (i.e. a data model + other stuff that you can simply ignore if you want to do ERD).  Any leading data modeling tool like ERWin or Sparx (professional and higher if I remember right) lets you choose what notation to use (IE/Crow's Foot or UML).  Yes UML handles PK/FK and FK migration just fine as stereotyped attributes.  You can also show triggers and indexes a stereotyped operations.  You can easily handle relationships with composite foreign keys (if that's what you mean by relationships between multiple attributes).

You can make conceptual, logical and physical data models easily in Crow's Foot.  Just click the notation you like by clicking on the Diagram options in Sparx.   There really is no significant difference in what you can do with UML or Crow's Foot / IE notation (google for details).

You can reverse/forward engineer from most leading DBMS with Sparx.  It's not as easy and fully featured as ERWin , Embarcadero etc; also relationship management is a little clunky, but anyway Sparx gets the job done at lower cost than dedicated data modeling tools.

There is a documentation PDF in the Sparx reference section that explains how to do all above.

Good luck!!
Mr QWERTY Sir, on my machine Start - Search - Browse for diagram, a "Select a diagram" window opens, Visible Diagram Types: there's a drop down box With only options being <All>, InteractionOverview, Sequence, Communication and Timing.  So for example I cannot filter only a Class or Use Case Diagram -  they don't appear in the drop down box.  Any suggestions welcome because I have a bajillion diagrams and I need to search them quickly.  Thanks!

General Board /
« Last post by Rajirmatio on October 20, 2018, 10:27:02 pm »
Ketozin  You can enter this data in your laptop at the end of the day.Your foods diaryThis will be an important tool for the getting part of your weight-loss strategy. The foods publication will explain to you, in grayscale, why you are obese and what getting and behavior workouts you need to change. You may be surprised how much foods you take in in a normal day.You may notice that certain moods, individuals, or circumstances accompany pig-outs.
Uml Process /
« Last post by TommyGadsden on October 20, 2018, 08:39:52 pm »
wellness insurance plan wellness and fitness and wellness insurance plan fitness. Exercise functions reduce whole personal bodyweight and bodily proportions.keto 6x Exercise restores our power helping us to produce muscular. Cut muscular allows us the use-up more calories and more fat. Truth: You must get educated about weight-loss. If reducing personal bodyweight has been a battle for you, you need to understand as much as possible about organic wellness insurance plan wellness and fitness and wellness insurance plan fitness and wellness insurance plan wellness and fitness, nourishment, and how the
General Board / Re: Escort
« Last post by SoFree on October 20, 2018, 07:55:11 pm »
As for me I call to escort girl every time when I want blow job, my girlfriend doesn't like oral sex, but i like it very much, so...)
General Board / Re: Logical Data Modelling in SPARX
« Last post by qwerty on October 20, 2018, 06:36:14 pm »
I only heard of DBMode MDG but have no idea how well it works.

General Board / Re: Importing glossary terms
« Last post by arine23 on October 20, 2018, 05:58:13 pm »
The article is very interesting. It is very new and very useful in .. Thank you very much.
General Board / Re: Importing glossary terms
« Last post by peaflowers on October 20, 2018, 05:55:09 pm »
Thanks for the good comments on the suggestions. I know a lot more.:ta
General Board / Re: Logical Data Modelling in SPARX
« Last post by DavidM on October 20, 2018, 04:28:37 pm »
Hi Sunshine - -exactly there is a difference between data architecture and OOA.

It looks like then that  Sparx doesen't support logical modelling outside of the OO arena where a table can have a combination of logical elements as a primary key e.g. FlightNo, Date, and the other tables would need to reference  these with foreign keys e.g. FlightNo,Date.

In the physical/OO world we can connect with a single GUID etc. but in the logical world, that is abstract from systems and technology, we have to go with business attributes, which of course is the whole point of logical modelling.

It's a shame we will have  to take our Logical Data repository out of the enterprise repository because something so basic in logical modelling is not supported, but at least I know it can't be done instead of struggling.

I don't suppose there are any MDGs out there that provide this is there?

Thanks everyone for your contributions.
General Board / Re: The mysteries of Roadmaps ... ?
« Last post by qwerty on October 20, 2018, 07:15:48 am »
Speaking of MS Project (argh!) I used faces which is Python based and just genius. Interestingly those Mickeysoft "products" still dominate the market though they are bloated and .... cut myself, rant-mode disabled.

Pages: 1 [2] 3 4 ... 10