Well, you are missing the importance of the associative class. Resolving
the many to many relationship isn't the only purpose of the class. There
is inevitably some information that must be captured at the associative
class level. Say you have two classes, Employee and Projects. There is
obviously a many to many relationship between these two classes. I want to
know how much time the Employee is spending on each Project and the role
the Employee participating on the project (e.g. business analyst,
programmer). This information needs to be stored at the associative class
level. An automatic associative resolution process (like provided in
ERwin) can't make the business modeling solutions to attribute the classes
correctly. Good old fashioned normalization can though.
Regards,
Walter Howard
Data Analyst
"Angay, Huseyin"
<Huseyin.Angay@egg. To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
com> cc:
Sent by: Subject: RE: (ROSE) Finding
many-to-many relationships without
owner-rose_forum@ra associative s
tional.com
02/14/2002 08:48 AM
Please respond to
"Angay, Huseyin"
Hello David.
Are you looking for a way of doing this in SoDA?
I';m not sure about SoDA, but it is relatively simple to do using REI. Look
at all the associations and make sure that the cardinalities of their roles
are not many.
Am I missing something fundamental?
Best regards,
H�seyin Angay
Karabash Ltd.
www.karabash.co.uk
> -----Original Message-----
> From: Fletcher, David [mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2002 09:59
> To: '[EMAIL PROTECTED]'
> Subject: (ROSE) Finding many-to-many relationships without
> associatives
>
>
>
> Hello list,
>
> Has anyone ever discovered how to write a report that detects
> the case of a
> many to many relationship that lacks and associative object?
> We are finding
> this necessary when generating database schemas from our very
> large class
> model.
>
> Thanks.
>
> David A Fletcher
>
> Digital hot desk number: 0870 904 5286
>
>
> **************************************************************
> ******************************
> " This message contains information that may be privileged or
> confidential and
> is the property of the Cap Gemini Ernst & Young Group. It is
> intended only for
> the person to whom it is addressed. If you are not the
> intended recipient, you
> are not authorized to read, print, retain, copy, disseminate,
> distribute, or use
> this message or any part thereof. If you receive this message
> in error, please
> notify the sender immediately and delete all copies of this message ".
> **************************************************************
> ******************************
> **************************************************************
> **********
> * Rose Forum is a public venue for ideas and discussions.
> * For technical support, visit http://www.rational.com/support
> *
> * Post or Reply to: [EMAIL PROTECTED]
> * Subscription Requests: [EMAIL PROTECTED]
> * Archive of messages:
> * http://www.rational.com/support/usergroups/rose/rose_forum.jsp
> * Other Requests: [EMAIL PROTECTED]
> *
> * To unsubscribe from the list, please send email
> * To: [EMAIL PROTECTED]
> * Subject: <BLANK>
> * Body: unsubscribe rose_forum
> **************************************************************
> ***********
>
This private and confidential e-mail has been sent to you by Egg.
The Egg group of companies comprises Prudential Banking plc
(registered no. 2999842), Egg Financial Products Ltd (registered
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
carries out investment business on behalf of Egg and is regulated
by the Financial Services Authority. All members of the Egg group
are registered in England and Wales. Registered offices: 142
Holborn Bars, London EC1N 2NH
If you are not the intended recipient of this e-mail and have
received it in error, please notify the sender by replying with
'received in error' as the subject and then delete it from your
mailbox.
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
*************************************************************************