Hello, I've been playing with Visio ORM and came across this interesting situation: I have the constraints between department and Employee: [Department] has...
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...
1370
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 8:10 pm
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...
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...
1372
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 8:44 pm
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, 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...
1376
Wolfgang Baeck
wbaeck@...
Jun 14, 2003 4:31 pm
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...
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...
1378
bmaclean@...
Jun 15, 2003 3:57 pm
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...
1379
bmaclean@...
Jun 15, 2003 3:57 pm
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...
1380
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 5:42 pm
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...
1381
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 6:06 pm
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 ...
1382
Stone, Ken
Ken.Stone@...
Jun 16, 2003 6:42 pm
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,...
1383
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 8:06 pm
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...
1384
Stone, Ken
Ken.Stone@...
Jun 17, 2003 12:29 am
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...
1385
Wolfgang Baeck
wbaeck@...
Jun 17, 2003 2:19 am
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, 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 ...
1387
Darryl L. Rowe
darrylr@...
Jun 18, 2003 11:37 pm
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 ...
1388
Chris Bruce
chris@...
Jun 27, 2003 1:35 pm
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 ...
1389
John Miller
jMiller@...
Jun 27, 2003 4:33 pm
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...
... 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...
1392
John Miller
jMiller@...
Jun 27, 2003 10:55 pm
Hi Andy, Here is Chris' original invalid model: http://www.pdata.com/wikifiles/images/orm1.jpg Here is my proposed solution: ...
1393
John Miller
jMiller@...
Jun 27, 2003 11:46 pm
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:...
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..." ... ...
