Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Transformer Puzzle in Rel 2.1 of Designer 2000

Re: Database Transformer Puzzle in Rel 2.1 of Designer 2000

From: Nicholas Wakefield <Nicholas.Wakefield_at_BTInternet.com>
Date: 1998/10/20
Message-ID: <70i1v7$r4t$1@plutonium.btinternet.com>#1/1

Valaray

Thankyou for your reply, however I had done this and my diagram tried to show this by means of the crosses at the tops of the crowfoots Valery A. Sorokin wrote in message <362C8A65.E8F4437_at_dd.ru>...
>I think both Relationship Ends for Entity C must be mandatory
>and with checked Primary UID check boxes.
>
> _____________ ___________
> | Entity A | | Entity B |
> |___________| |__________|
> : :
> : :
> : :
> | |
> | |
> _|_ _|_
> /|\ /|\
> _ /_|_\ ______________________/_|_\_
> | Entity C |
> |____________________________________|
>
>
>
>I hope this will help you.
>
>Nicholas Wakefield wrote:
>>
>> I have two versions of designer in my office 2.1 and 1.3.2 and when I
 create
>> an application
>> with the entity realtionship model like the one below, I get two
 completely
>> different answers
>> _________ _________
>> | Entity A | | Entity B |
>> |________| |_________|
>> | |
>> | |
>> | |
>> : :
>> : :
>> _:_ _:_
>> /|\ /|\
>> _ /_|_\ _______/_|_\_
>> | Entity C |
>> |________________|
>>
>> 1.3.2 - Creates two new foreign key columns in entity c, which form the
>> primary key - which is what I want, when put through the database wizard.
>> ...Whilst ...
>> 2.1 - Creates a sequence identifier(surrogate) for the primary key and
>> two optional foreign key columns entity c, when put through the database
>> transformer.
>>
>> Could someone please tell me why as it has got me baffled.
>>
>> Regards
>> Nicholas
>
>--
>Valery A. Sorokin
>ProSoft, Russia, Moscow, Information Systems Division
>Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
>E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
>http://www.dd.ru
Received on Tue Oct 20 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US