Hello, I've been playing with Visio ORM and came across this interesting situation: I have the constraints between department and Employee: [Department] has...
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 7:00 pm
1369
I got the same results - however it all depends on how you define the subtype. If you allowed for default mapping then the manager is part of the Employee...
Pat, Thanks for trying it out. I did exactly what you did before I posted and it doesn't create the three tables. I use Visio EA 10.0.2705 Did you do something...
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 8:10 pm
1371
Sorry - yes I did and an attribute to manager. I tried that first. It did not work because of the option for subtype mapping. So now between the 2 fo use we...
Doesn't work for me in my settings. Attached is a zip file if you would be so kind and look at it. Open the Logical1.vsd as the logical diagram having all...
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 8:44 pm
1373
Wolfgang, your original solution is fine (see attachment for conceptual and logical models). The Department table allows the same employee to manage many ...
This is what you got and I think it is correct. You have a manager table. Your have a department table. In your ORM model you put: Notice the uniqueness...
Here is another thought: I did not check this out, but assume you wish to record when the manager began managing the Department. Then you would have to create...
Is there a way in VISIO EA ORM to provide the derivation rules for facts in such a way that when the Physical Data-type SQL Server is selected it will end up...
Wolfgang Baeck
wbaeck@...
Jun 14, 2003 4:31 pm
1377
The RMAP routine does not create derived columns (virtual columns). I assume you mean columns that are not actually part of the table as such, but can be...
Pat is correct that there isn't any to use ORM to specify the rules. However, you could mark a fact as derived and stored, which will make an actual physical...
bmaclean@...
Jun 15, 2003 3:57 pm
1379
Pat is correct that there isn't any to use ORM to specify the rules. However, you could mark a fact as derived and stored, which will make an actual physical...
bmaclean@...
Jun 15, 2003 3:57 pm
1380
Hi, I need to extend the following model and would like your input. The following are some facts that are not necessarily part of this model but are required...
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 5:42 pm
1381
Sorry for trying to have the pictures in the message. They are attached now. Wolfgang Hi, I need to extend the following model and would like your input. The ...
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 6:06 pm
1382
Hello, Mr. Baeck: Why do your customers want to assign tasks directly to individuals? Is it because they relate better to the people performing the roles,...
Stone, Ken
Ken.Stone@...
Jun 16, 2003 6:42 pm
1383
Ken, It is because they can envision tasks being assigned that are neither due to a FosterHome or a FosterChild. I would argue that they should use the...
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 8:06 pm
1384
Wolfgang, Why not integrate your workflow management system with Outlook, to publish all tasks on the Outlook task list? Regarding your model and the problem...
Stone, Ken
Ken.Stone@...
Jun 17, 2003 12:29 am
1385
Ken, Thanks for the additional abstractions, they are helpful. Now to the integration with Outlook. The problem here is, and that's why it has been abondoned,...
Wolfgang Baeck
wbaeck@...
Jun 17, 2003 2:19 am
1386
Wolfgang, Automatic reassignment may be impractical in Outlook as-is, but it might be easy in other workflow engines/toolsets that work with queues of tasks ...
Or, perhaps, instead of using the _user's_ Exchange mailbox, have a seperate "folder" in the "Public Folders" area and then just assign/reassign it with ...
Darryl L. Rowe
darrylr@...
Jun 18, 2003 11:37 pm
1388
Hi, The general principle of a full span UC on nested facts I'm happy with. However I've come across a problem when the fact is representing temporal ...
Chris Bruce
chris@...
Jun 27, 2003 1:35 pm
1389
Hi Chris, I've argued that the full spanning UC requirement for nesting unnecessarily contributes to the instability of the model and your scenario is another...
John Miller
jMiller@...
Jun 27, 2003 4:33 pm
1390
... From: John Miller [mailto:jMiller@...] Sent: Friday, June 27, 2003 10:38 AM To: jcm@yahoogroups.com Subject: RE: [JCM] Problem with mandated full...
Sometime the ternary do get broken down because of the current rule. That rule will change in the future. However, now you have set of binaries and no ternary...
Hi Andy, Here is Chris' original invalid model: http://www.pdata.com/wikifiles/images/orm1.jpg Here is my proposed solution: ...
John Miller
jMiller@...
Jun 27, 2003 10:55 pm
1393
Hi Pat, It's stable if you model only with binaries. jMM'. ... From: Patrick Hallock [mailto:path@...] Sent: Friday, June 27, 2003 3:18 PM To:...
John Miller
jMiller@...
Jun 27, 2003 11:46 pm
1394
Hi John, Yes I was missing something, thanks for your clear and very helpful explanation. I will have to add "stability" to the possible positives of allowing...
Good set of drawings. I was suggestion the removal of all nesting. Use A, B, C in a ternary - A uses B with C. Put a constraint over any two. You cannot nest...
Andy, Terry has taken that position in the past and had good reasons for doing so. However, I believe he has changed his mind about this. Yes, people do change...
Sorry folks, I'm just resending this because some mailsweeper didn't accept a 4-letter word I used in the phrase "non-expert modelers would m_ff up..." ... ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
