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: Valery A. Sorokin <vsorokin_at_dd.ru>
Date: 1998/10/20
Message-ID: <362C8A65.E8F4437@dd.ru>#1/1

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