The ORM Foundation

Hi Marc, This is, if I'm not mistaken, a DDL script based on the ORM diagram I posted. I was looking, rather, for some indication of what is the schema that you're trying to write your constraint for, in SQL. But maybe I should make sure of this question first: Are you planning to re-do a current relational schema (to make it ...

Hi Marc, I have responded in-line, like  >> this [quote user="mnnoon"] Yes that seems to reflect accurately the way I currently want to design the database, thanks.   >> Good, now we can go ahead and address finer details (e.g. see below). ... I'm not sure how you added those light blue ...

Hi Marc,  Does the below seem to reflect accurately the fact types and business logic in view in the domain (of your "watered-down example")?   I gather that the actual, existing database has a "CostOfLiving" table. This seems like something that needs correcting, rather than reflecting accurately the fact types of ...

Hi Marc, Sounds like an interesting modeling problem. I think it would make it clearer, however, if you could give one or two concrete examples (e.g. table rows) of data used in these fields... and maybe even offer an interpretation of these data use cases. If you can't share any of the real data, please invent one or two such examples. ...

Hi Roger, Due to your patience and persistence, I've some good news to report. I've found what the real problem was, with the behavior I was excoriating in Visio 12 and ff., and have fixed this problem in the stencil. So, you should now be able to re-color the whole fact type, or individual roles (if desired), without such anomalies as ...

Thank you Roger, you've reminded me of this (annoying) problem that, as it turns out, is in Visio 2007 as well (and maybe 2003). Visio 10 (2002) does behave as I described, which is a very helpful feature; but that got screwed up somewhere along the way, and unfortunately it appears they've yet to fix it. As you've ...

P.S. I just realized that if the above suggestion works in your Visio, then adding some custom property, say -- which would require moving from the context menu to the Custom Properties menu, to select one's desired color -- would not save the user even a mouse-click, but rather, only the moving of the mouse-pointer to a sub-menu. So let me ...

Hi Roger, Thanks for your perceptive post. I agree that it needs to be pretty easy, in Visio for example, to change the shading of the role boxes to some color you use a lot (e.g. to denote derivation). And I would certainly want to make it easy enough in the Visio stencil. However, I do want to mention that I have not found it ...

Hi Roger, Terry has brought to my attention your request regarding the ORM2_Draw2 Visio stencil. I've just uploaded a new version (11) that adds a "link binary" fact type shape. Also I added a couple of paragraphs to the readme file, in the section on "Use of the new features", regarding this shape and its ...

Hi Clifford, Interesting example, but I'd say you were on the right track with your unary fact type but were somewhat misled by thinking the cardinality constraint (of #1)applied to the "value" type. Actually, there is a cardinality constraint, but not on the value type so much as on the role. For example, if I had the unary fact ...