Multiplicity is the key factor in determining which PK gets transformed to FK.
I have tried the Address with multiplicity of 0 or more (0 .. *) and the State with multiplicity of 1 based on the assumption that a given State can have 0 or more Addresses. Please let me know if you would like me to send you the sample model. Data Modeler manual also has some examples and again let me know if you do not have this manual and I can send you the pdf file. Sonny > -----Original Message----- > From: Barrett, Kathy (PLC, IT, Lambert Technical Services) > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 11:14 AM > To: '[EMAIL PROTECTED]' > Subject: (ROSE) Transforming Object Model to Data Model (Oracle) > > > > I am trying to understand how relationships are transformed > from the Object > Model to the Data Model (using an Oracle database). My > experience is in the > relational world, and I'm new to Object, so please excuse my use of > terminology. > > Here is my example. > > I have two classes, Address and State. In the object model, the > relationship is from Address (parent) to State (child). When code is > generated, state is an attribute in the Address class. This is what I > expect. > > When I transform the object model, a foreign key column > (address_ID) is > created on the state table. This is not what I expected. > From a data model > perspective, the parent in this relationship should be State, > not Address. > > Does a parent/child relationship have a different meaning in > the object > world? > > Is this a bug, or a lack of understanding on my part? > > Any help is appreciated. Thanks. > > > This communication, including attachments, is for the > exclusive use of > addressee and may contain proprietary, confidential or privileged > information. If you are not the intended recipient, any use, copying, > disclosure, dissemination or distribution is strictly prohibited. If > you are not the intended recipient, please notify the sender > immediately by return email and delete this communication and > destroy all copies. > > ************************************************************** > ********** > * 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 *************************************************************************
