Re: E/R diagramming question
Date: 1995/09/16
Message-ID: <43dq2p$hkb_at_sulla.cyberstore.ca>#1/1
> tadams_at_connect.net (Tom Adams) writes:
>
>> < snip: question about showing foreign keys in logical E/R/model>
> > < snip: good explanation about "no need to show this in logical model"
>>>>
To the original poster,
If you come from a different background than Oracle*CASE (aka Designer/2000) methodology, you probably weren't aware that in Oracle's methodology, the foreign keys are implied in the 1:M (one to many) relationship between the 'parent' and 'child' entities. Some methodologies (like IDEF1X) explicitly show the migrated foreign keys, but Oracle's doesn't.
In the the Oracle 'world', these migrated keys automatically get generated when you run the Database Design Wizard. So, as the last poster said, these foreign keys don't show up until the physical model.
Gary Wong (gary.wong_at_cyberstore.ca)
Information Technology Consultant
(604) 360-1699 (Voice)
(604) 384-1178 (Fax)
Received on Sat Sep 16 1995 - 00:00:00 CEST