You must have misunderstood. I am well aware of normalisation techniques.
The original question was about how to find the classes that have
many-to-many associations without an associative class. I assumed this meant
a many-to-many that hadn't been reduced to a couple of one-to-manies through
a synthetic associative class.
Now, the technique to find this in Rose (as long as you are happy to code
it, naturally) is quite straightforward, as I explained previously.
It is, in fact, so simple that I was wondering if there was something wrong
in my assumptions and that David was expecting something more elaborate.
If you want to get cleverer and keep your class model intact whilst
providing the normalisation hints, you can also create association classes
to hold the information for the associative class. That way, you get to keep
the meaning of the many-to-many association, if there is something more
significant about it. Still, the technique to spot where this work hasn't
been done is much the same: go through all the many-to-many associations and
see if they have a LinkClass.
Some poor human will still need to enter that information manually, but
we can at least help them spot where the work has not yet been done.
Best regards,
H�seyin Angay
Karabash Ltd.
www.karabash.co.uk
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2002 14:58
> To: [EMAIL PROTECTED]
> Subject: RE: (ROSE) Finding many-to-many relationships without
> associative s
>
>
>
>
> 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
> **************************************************************
> ***********
>
************************************************************************
* 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
*************************************************************************
